Hello,
I am making a report and need to have two separate totals in the report. What it is is a database that tracks the yardage of material rolled by two different winders. For simplicity let's just say winder 1 and winder 2. in the report I need to have two distinct totals of yardage consumed, one total for winder 1 and one total for winder 2. However, I would still like to display my other fields (RollNumber, YardsConsumed, WinderNumber, EmployeeNumber, Shift, and EntryDate) in the report. I have made two separate queries: one that finds the information I need for winder 1 and one that finds the same information for winder 2. Any help is greatly appreciated!