i have a query that runs and extracts all of the items for all users who match the criteria (bill today, Active, etc.)
What I want to do is be able to generate a total for each user in the query based on the cost for each item they have.
example... the query runs and generates 5 records. 3...