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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Queries have properties, including "Unique Values". If you set this to
"Yes", does that return only unique IDs?
 
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

Duplicates by Partial Matching (MS ACCESS) 5
Querry to get unique records from 3
match middle initial with middle name field 2
Crosstab query (I think) 4
Moving duplicate records to a separate table. 2
Query that will look for duplicate in two tables. 3
Multiple records in a query 4
Help Me Fix This Querry 1

Back
Top