J Jeff Boyce Dec 17, 2007 #2 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
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
