Delete Dups in query

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

Guest

All I want to do is delete duplicate entires in a Query.
I've read and tried SQL Distinct code, Update Queries, etc.
But what is the simplest and queskest way to simply remove duplicate entries
in a query??

Thanks
 
From design view of the query, click properties. There is unique values and
unique records. I think you want unique values.
 
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

Deleting dups out of a table or query 1
Eliminating Dups??? 1
Delete Dups Query Failing 3
Please help with Query "dups" 7
Combine Duplicates in Query 0
Delete dups in a table 3
How to get this table updated with a result from another query 2
why isn't this query FAST!? I've tried EVERYTHING! (query performance issue) 5

Back
Top