Greetings, WorkOrderF has two subforms (WorkOrderLaborF / WorkOrderPartF). The both subforms will have the same laborer/part recorded multiple times at different dates. I have totaled both subforms in different queries (WorkOrderLaborT Query / WorkOrderPartT Query) they work fine. I made a query for the WorkOrderF (WorkOrderPrintQ) to pull all the info for the report. The problem is when I put the 3 queries into a report, I get duplicate records. Any suggestions on how to correct this? Attached db copy for reference
MooreV4-1.zip