find duplicates list as singles

[Guest]

I have a table in which some samples are run twice for quality control. I
want to from this table make a list of the samples that I have ran more than
once, however when I find the duplicates I only want them listed once. When
I do a query to find duplicate records it lists the samples as many times as
they have been run. I only want them once. HELP!!!!

 

[David Seeto via AccessMonster.com]

It sounds like what you need to do is to limit the output of your
duplicates query using the Group By clause - in the Query Designer for the
resulting query, righht click anywhere in the field table and click on
"Totals". You should then get a row in the field table between "Table:" and
"Sort:" that says "Total:". They will default to "Group By".

When you run your query, you should now see only one of the duplicate
samples.

If you have further problems, could you paste the SQL code and your table
structure here so we can do better at solving your problem?

Cheers!