Given a set of records within specified date range, I want to combine and total records of the same type. In the screenshot below, take for example the records that are in the category "Collected Dues". What I want is a single entry in the report for the category "Collected Dues" with a total of $585.00, the total of the 4 records shown. (The date field is no longer pertinent and will be removed from the report) So, the single line would read "Collected Dues" as the description, "Collected Dues" as the category and the amount $585.
The reports "RecordSource" is a query that includes "CatID", which is the record ID in the table "Categories". The user will specify in the apps settings which categories are to be combined when reports are run and the app will query accordingly.
Where does such functionality belong? Something in the queries SQL? Grouping?