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

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
 
L

Lord Kelvan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Duplicate records only once 3
Problems with COUNT in Query 2
Display a count of unique records in a query in Access 2007 6
How do I query non-donors in Access? 1
Access queries 2
How Create Sum for Sort? 1
Selecting REMAINING records by excluding others 2
Using the Count function in a cross-tab query 1

Top