Group and only show duplicates

  • Thread starter Joshua K Briley
  • Start date
J

Joshua K Briley

Weird question here. I've got a query set up that shows the following
information:

SampleNumber
DateOrdered
KitNumber

So far so good...

I'm trying to group this information (in a report) by Kit Number, because
I'd like to find out which kits have been used multiple times. I'd like to
see the SampleNumber and DateOrdered as a sub group of the KitNumbers that
have been used multiple times... excluding those kit numbers and grouped
information that have been used only one time.

I hope I'm making sense. Is there a simple solution for this? Any advice
will be greatly appreciated?
Somecallmejosh
 
R

Robert_DubYa

Create a new query based on the same table. Count the number of times the
kit appears. Use >1 for your criteria. Use this query and join with your
current query off the kit#.

I hope I understood you correctly.

You could also use a sub query to do this, but it is a bit more difficult.

RW
 
K

Klatuu

The Query Wizard provides a Find Duplicates query that works well. Give it a
try.
 
Top