I am working on a report that will total individual inventory quantities from various locations. The results will be multiplied by the value to produce a total value amount. I have everything the way I need it except I need to total the quantities.
It would be acceptable to either do the total in the attached query or I can create a table and use that data to total the quantities.
I am attaching both the Access SQL and s sample of the results of the query (without the totals).