Multiple Group Totals (1 Viewer)

mounty76

Registered User.
Local time
Today, 03:08
Joined
Sep 14, 2017
Messages
341
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!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:08
Joined
May 7, 2009
Messages
19,175
group them using CInt(Val([Budget Code]))
your Final Query is query2, see also query1.
 

Attachments

  • queryDB.accdb
    472 KB · Views: 380
Last edited:

Pat Hartman

Super Moderator
Staff member
Local time
Today, 06:08
Joined
Feb 19, 2002
Messages
42,981
Do the grouping in the report rather than in the query.
 

Users who are viewing this thread

Top Bottom