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....
 
Top