hide duplicate data in a query

G

Guest

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!!
 
G

Guest

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
 

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

Combine Duplicates in Query 0
deleting duplicate records obtained from a duplicate query 4
Duplicates in union query 3
Append Query Issue 0
Duplicate Query based on two duplicates 7
Append query without duplicate rows 3
remove duplicate records in Access 2007 7
challenging query 3

Top