This is the most intimidating query or programming I have ever contemplated. I am not even sure that this is something to be done in Access, or export the data to Excel and perform calculations there. Structure first.
Fees table with the fields ProcessCode and ProcessFee.
Inventory table with ProcessCode and BoxingType.
WOTracking table with Process, SKUQty, SKU, ContractCo, Date_Time, and OrderNo.
Table Relationships:
WOTracking to Inventory by SKU
Inventory to Fees by ProcessCode
Fees to WOTracking by Process
Objective is to query WOTracking for orders between date range. Use WOTracking.Process to get Fees.ProcessFee for each item on order. Sum ProcessFees for order. Get Fee.BoxingFee based on Inventory.BoxingType WHERE SKU is = WOTracking.SKU.
HandlingFee = 1.75 + ([SKUQty] - 1 * .50)
SUM ProcessFee, BoxingFee, and HandlingFee per Order.
Am I trying to do too much?
NOTE: This is what ambition with a lack of knowledge lead to. Recommendations would be greatly appreciated.