No duplications

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?
 
J

Jason Lepack

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
 
Top