No duplications

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

I have a query that shows many records with the same "Part Number". I want
to create a query that shows only the Part Numbers without duplications.
Any ideas anyone?
 
You don't give enough information for us to help. You could want a
"distinct" query or a "group by" clause. It all depends what other
data you want to show.

Post the SQL by going into design view and selecting SQL View and then
post it here along with a description of what you expect to see and
links between tables that are used.

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 Duplicates in Query 0
Access Compare records in same access table 0
Query based on Query 1
Duplicates in union query 3
Access Auto Matching Duplicates? 0
Requesting Help Ranking Sales Values..... 6
Multiple records in a query 4
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0

Back
Top