Group and sum in a query (1 Viewer)

[mounty76]

Hello,

This should be easy but I'm bang my head against a brickwall...

I have a table which has amongst others the following fields:

Budget Code - This is linked to another table which has the various codes in
Cost
Date

With data something like

4300 Training 100.00 12/1/21
4210 Travel 120.00 23/4/21
4300 Training 50.00 2/6/21
4210 Travel 80.00 25/9/21

I want to group together by Budget Code and then to sum the costs so it would look like:


4210 Travel 200.00
4300 Training 150.00

Should be easy I think!!

Thanks in advance!

 

[plog]

That is easy, what have you tried? Here's a microsoft tutorial page for it:

Sum data by using a query - Microsoft Support

Learn how to use an aggregate function in Access to sum the data in a query result set.

support.microsoft.com

 

[mounty76]

Only easy when you know how!! Have looked through the tutorial page but nothing I try seems to work

 

[mounty76]

Done, thanks