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!
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!