How to stop duplicates in a query or report

W

Walt

Hi,

I'm a access novice and need help. I have a table that has duplicates in
several columns. I want to know if there is a way to query the database in a
way to surpress duplicates?

I appreciate any assistance. Thank you
 
J

Jeff Boyce

Walt

You can set the Unique Values property of the query to only return unique
values. This doesn't eliminate the duplicates, it just doesn't show them.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
W

Walt

Thank you Jeff, that did it.

Jeff Boyce said:
Walt

You can set the Unique Values property of the query to only return unique
values. This doesn't eliminate the duplicates, it just doesn't show them.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 

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

Access Auto Matching Duplicates? 0
Find Duplicates 1
Duplicate showing in query when there shouldn't be 10
REMOVING DUPLICATES 4
Deleting all duplicates 1
Allow duplicates, but not for the same reference 5
Deleting Duplicates in the same table. 1
Augmenting an integer in a column to reflect duplicates in another 23

Top