Eliminating duplicates in Access 2007
in [Queries]
|
Prev: howto copy only newer OrderID data(and the other fields) from one table to another table
Next: Return all dates for 'next month' irrespective of year or day
From: Doones on 1 Mar 2010 17:15 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! -- Lorna
From: PieterLinden via AccessMonster.com on 1 Mar 2010 17:39
Doones wrote: >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! Instead of SELECT Field1, Field2... FROM MyTable.... use SELECT DISTINCT Field1, Field2... FROM MyTable.... -- Message posted via http://www.accessmonster.com |