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...
 
Top