I have a database with a table of part numbers and quantities received, and I want to add up the quantities received to get the annual usage for each part number. Example:
Part Number A had 500 pieces received in September, 600 pieces received in October, 1500 pieces received in November, etc.
Part Number B had 1000 pieces received in September, 1200 pieces received in October, 450 pieces received in November, etc.
Is there an expression that will add all the number of pieces received for each part number?
So many questions asked about Access already, but I did try finding the answer first!
Cheers.