How to stop duplicates in a query or report

  • Thread starter Thread starter Walt
  • Start date Start date
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
 
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
 
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...
 
Back
Top