Hiding duplicates in a query

  • Thread starter Thread starter Ron DeGregorio
  • Start date Start date
R

Ron DeGregorio

Is there a way to hide duplicates in a query? I would like to use a make
table query to make a lookup table but I need to see only 1 of each
repeating for the lookup table.
 
Sounds like a totals/group by query to me. Have you tried View->Totals?
 
Create your query then right click in the query window where your table is
at. Click on Properties in the dialog that appears. Set the Unique Values
property to Yes.
 
You must log in or register to reply here.

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
Customer DB Duplicates 3
Append Query Issue 0
Duplicates in union query 3
Append query without duplicate rows 3
deleting duplicate records obtained from a duplicate query 4
Hide duplicates in a query ... 2
Make one final list from four sources 1

Back
Top