Multiple Group Totals

mounty76

Registered User.
Local time
Today, 14:27
Joined
Sep 14, 2017
Messages
350
Good Morning!!

I have a total qry which returns the following:

Budget Code(Group By) SumOfBudget (Sum)
0.01 Management 50000
0.02 Bank Charges 6000
0.03 XXXXXXX 10000
1.01 XXXXXXXXX 20000
1.02 XXXXXXX 30000
2.01 XXXXXXXXX 40000
2.02 XXXXXXXXXXX 2000

Etc.... down to 9.XX

What I would like to do is group these and sum them with custom name, EG:

0 - Management Costs (Sum of all 0.*)
1 - Operational Costs (Sum of all 1.*)
2 - Staffing costs (Sum of all 2.*)

etc.... down to 9.*

You'd think this is simple but I'm not getting anywhere, any points much appreciated!
 
group them using CInt(Val([Budget Code]))
your Final Query is query2, see also query1.
 

Attachments

Last edited:
Do the grouping in the report rather than in the query.
 

Users who are viewing this thread

Back
Top Bottom