Unique items in Recordset

[knowledge76]

Hi experts,

Today morning I am asking myself the question how I could get unique items in a recordset. I have a parts table and for each part there should be approriate description available. Now for some parts there are no description available and as one part can come many times in this table. For a part that ten time present in this table and its description is missing. My code would inform me that part 10 times that its description is missing. How can I get that specific part to be shown once and not t10 times?

 

[namliam]

Try an unmatched query and then click on the "Sigma" button to "group" your query.
The sigma button looks like a M but then sideways like E....

Good luck

 

[knowledge76]

Thanks I had more or less the same idea. Thanks I tried it and it works fine.
Thanks again for the quick reply.