Jeff
Create a new query in design view.
Add the table with the part numbers.
Click on the Totals button (looks like a "sum of" button from Excel).
Add the [PartNumber] field ... leave the aggregation as "GroupBy".
Add the table's primary key field ... change the aggregation to "Count".
Run it.
Regards
Jeff Boyce
Microsoft Office/Access MVP
