remove duplicates

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hello,

How can I make a query on a specific field of a column so that it return all
the values of the field but without showing duplicate entries?

Thanks,

Daniel
 
Hi Daniel
If you right click somewhere in the Query Design Grid and select Properties
from the menu, you can change the Unique Records property to Yes.
Alternatively, if your query is counting records then show 'Totals' in the
grid and then select GroupBy.
HTH

Lee
 
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

Repost: Single result listing 1
Combine Duplicates in Query 0
Finding a count of duplicates 4
Deleting Duplicates 1
Duplicates 4
Access Auto Matching Duplicates? 0
Split data in field on character return 0
Dupalicate Query can show other field too 1

Back
Top