Select duplicate items in a query

D

danka

Hello:

I need to run the following query.
Table
Inspection Report Item #
1234 1
1234 1
1234 3
1235 1
1235 2
1235 3
1235 3
1235 4

I would like to select records that have duplicate item number for the same
inspection number. For example, 1234 has two items #1 and 1235 has 2 items
#3.
Can you help?
 
K

KARL DEWEY

Use a totals query. Have the following fields --
Inspection_Report Item Item
In the Totals row have --
Group By Group By Count
Set criteria for the second Item to >1 so it will list those that have
2 or more.
 
Top