hide duplicate data in a query

B

BryanE24

I have a table in Access that has duplicate records. I want to design a
query that will only show one instance of each duplicated record. I have
tried many things with no luck...Please Help!!
 
K

Klatuu

Open your query in design view.
Right click in the tables area (top part)
Right click and select Properties from the menu
Select Unique Records
 
Top