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 records are the same user user 1 and 2 records are another user, user 2

can i add a field that will give me the total for all of user 1's items and a total for all of user 2's items.

Thanks

hope this makes sense http://www.access-programmers.co.uk/ubb/smile.gif

Use a totals query, the sigma button on the toolbar, GroupBy UserID, Sum ItemCost, Or use the Report Wizard to build a report with the same conditions.

You cannot return BOTH detail and summary information in the same query. Use a report to calculate the subtotals you need.