hide duplicate data in a query

  • Thread starter Thread starter Guest
  • Start date Start date
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!!
 
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
Hide duplicates in a query ... 2
duplicates query 2

Back
Top