Sub Totaling in a report

[keiath]

Hi guys

I have a report that is generated completely from a Query/subform



26/00247/22S013 AGM Meeting 7th May 2013 - RAD 7th may 2013 999 A 52 General Expenses £130.00
28/00257/22S013 AGM MEETING FEFUND FOR HALL HIRE DEPOSIT H 999 A 52 General Expenses -£100.00
30/01217/22S012 Bank Charge - Bank Charge 999 A 52 General Expenses £180.09
06/00287/22S012 Ken/Prop0 T C Arnold 95954 A 55 All Grounds Maintenance £280.00
30/00267/22S013 Accrual C/F A 55 All Grounds Maintenance -£650.00

and the report looks like this, its a continuous run of invoices, what I want to do is sub total by Expense Code (52, 55 ect) just so you know there are 96 codes.

26/00247/22S013 AGM Meeting 7th May 2013 - RAD 7th may 2013 999 A 52 General Expenses £130.00
28/00257/22S013 AGM MEETING FEFUND FOR HALL HIRE DEPOSIT H 999 A 52 General Expenses -£100.00
30/01217/22S012 Bank Charge - Bank Charge 999 A 52 General Expenses £180.09
£410.09
06/00287/22S012 Ken/Prop0 T C Arnold 95954 A 55 All Grounds Maintenance £280.00
30/00267/22S013 Accrual C/F A 55 All Grounds Maintenance -£650.00

And so on, can it be done and how do I do it?

[June7]

Use report Grouping & Sorting feature with aggregate calcs in group footer.

What field has the expense code?

[keiath]

"Exp Code" is the field

[June7]

Then use that field to create a group header/footer in the report with a textbox in header or footer to sum on amount field: =Sum([field name])

[keiath]

I have created the report and it groups by code that works fine,

But I am unsure what you mean =Sum([field name])?

the two fields are Exp Code and Invoice Amount

[keiath]

Attached is how the report currently looks

What I would like is after the Group is listed to then Sub Total that group

Hope that makes sense

[June7]

What is your question? Do you want to resolve the #Error in the textbox? What is the expression?

[keiath]

That's the problem actually I am not totally sure i know what I am meant to be putting in the footer!, but below is how i would like the report to look

Accountancy Fees
11/03/2013 Acctant, Solicitor & Prof Fees - 295:Rou 9001399 2012-09-30 2,880.00
2,880.00
General Expenses
30/11/2012 Bank Charge - Bank Charge 180.09
26/04/2013 AGM Meeting 7th May 2013 - RAD 7th may 2013 130.00
28/05/2013 AGM MEETING FEFUND FOR HALL HIRE DEPOSIT HH1223 (100.00)
210.09

the Boldc in the end Column

[June7]

What is the field that has the monetary amount?

Did you use expression in the textbox Control Source property like:

=Sum([name of the monetary amount field goes here])

That textbox must be in the Group header or footer section, not Detail section.

[keiath]

Hi yes that works now, and sums the invoice in that group.

But its before the listing is there a way to have it after the listing?

So that you have Group Description at the top

then repeated again with the sum after the invoice listing?

[June7]

Go to the Grouping & Sorting window of the report designer. Will have to activate the Footer for the group. Put textboxes in footer.

[keiath]

Thanks

That works great