I would like to calculate OTD for each month of the current year seperately. I would like to group for each month the ship to location with a subtotal of OTD for each location. I would also like to subgroup the different jobs/parts for each location with an OTD percentage for those as well if possible. I have fields: Date (date of shipper), Quantity, Ship to, and job number. This would require using the fields: early, on time, and late but would not require these fields to be visible on the query. The calculation needs to be based on the quantities of each part of each shipment NOT based on how many shippers are marked on time, early or late.
Stumped
Access 2010