To use the INNER JOIN syntax, you’d rewrite the query like this: SELECT Donors.DonorID,Donors.Donorname. DonationRecords.DonationAmt FROM Donors INNER JOIN DonationRecords ...

I'm a total SQL n00b, so forming complex SQL statements is kind of new to me. I'll give your query a shot tomorrow and let you know how it goes.<BR><BR>Thanks!