Eliminating duplicates in Access 2007

D

Doones

I have done a query in Access and duplicate records are showing up and I'd
like to have the duplicates not be displayed. Can someone assist me with
this. Thanks!
 
P

PieterLinden via AccessMonster.com

Doones said:
I have done a query in Access and duplicate records are showing up and I'd
like to have the duplicates not be displayed. Can someone assist me with
this. Thanks!
Click to expand...

Instead of
SELECT Field1, Field2...
FROM MyTable....

use
SELECT DISTINCT Field1, Field2...
FROM MyTable....
 

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

How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Multiple records in a query 4
Query the same table three times 0
Duplicates in union query 3
Duplicate entry in a column/row 14
deleting duplicate records obtained from a duplicate query 4
remove duplicate records in Access 2007 7
Need Help Combining Records with Duplicate in some fields 0

Top