Can I set a querry to omit instances of repeat ID numbers

W

welshgirl

I have allowed a database to use duplicate IDs
I need to set up a query to omit all the instances of duplicate IDs
can anyone help please?
 
J

Jeff Boyce

Queries have properties, including "Unique Values". If you set this to
"Yes", does that return only unique IDs?
 
Top