Filtering "No Duplicates"

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

Guest

Good Morning,
Could anyone tell me how to write an expression in a query to basically say
"No Duplicates" I only want to use this in one coloumn.

Cheers

FFM
 
It all depends on how you define a duplicate...

This is my gut reaction:
SELECT DISTINCT * FROM [Your Table Name]

Cheers,
Jason Lepack
 

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

Combine Two Queries in Different Layouts 2
Queries 2
Duplicate Invoice Query 1
Combine Duplicates in Query 0
Duplicate a record 1
Access Auto Matching Duplicates? 0
Duplicates 4
FIRST record in a match 2

Back
Top