Mailing Query Question

[bobbyfunk74]

I have a query which narrows down a database of donors to only display people who have donated since 2005. Now the problem I have is when someone donated on several occasions it displays that person each time they gave.



What I am trying to do is come up with something recognizes when a person has been entered multiple times, and to only display their name once. This is going to generate a long list of labels for a mail-out and I don't want multiple letters being mailed to the same person.

Any advice on making this happen would be great!

[RuralGuy]

Have you looked at the DISTINCT keyword?

[goaqualogic]

I was having the same problem and it took a lot of fumbling for me to find the solution. Use Help in Access to look up "Unique Values" or "Unique Records". You change them through the Query Property Sheet.

I used Unique Values and then created a query which had only the mailing info on it. Then when I run it, it shows only one record for each customer and I created a labels report based on that query. Hope that helps.