duplicate names in a query. How do I hide duplicates?

  • Thread starter Thread starter snorman
  • Start date Start date
S

snorman

I have created a query Donors To Two Agencies so I have donors names listed
more than once. I want to get rid of the duplicate donor name
 
this is most likly happening because there are duplicate records that
either link to the donor or multiple records to remove them you have
to go into sql view to get there if you dont know is open your query
click on view in the menu bar and you will see sql view

next look for the word select and replace it with SELECT DISTINCT

make sure there is a space after the word distinct

hope this helps

regards
kelvan
 
Back
Top