I have two tables - tblPartNumber, tblQuanityScrapped
tblQuantityScrapped fields used:
My query is a date parameter query on ScrapDate. What has been requested is a query that totals the quantity of each part for the month. For example Part 123 could have 25 for Month 1, Part 124 could have 35 for Month 1 with the process being repeated for each month in the query.