I have an Access form that tracks inventory. For each item, one of the subfroms contains several numerical fields (e.g. issued_before, issued_after, etc). There can be several records for the subforms (differentiated by item_location). I want to display the sum of all these numerical fields for all locations for a particular item. Example:
The total issued on the main page should be 19. I've tried creating a query that sums each field (i.e. issued_before and issued_after) individually, but when I try to access those fields in the form, I get an error message. Any suggestions? Thanks!