Sum of a Sum on a query

[keiath]

Hi Guys wondering if you can help



I have a table that has long list of invoice for each 'Site No' thats anchored by a Group Code and a Exp Code (there is never a situation when an invoice does not have these) I then have a Query that is a subform that is a summary of that information and looks like this:-

Expense Description	Group Code	Exp Code	SumOfInvoice Amount
General Expenses	A	52	£210.09
All Grounds Maintenance	A	55	£9,023.20
All Lift Expenditure	A	59	£499.20
Refuse Collection	A	64	£3,010.76
Pest Control	A	67	£1,146.00
Electricity	A	79	£1,294.59
Insurance Premiums	A	87	£238.50
Accountant & Solicitors Fees	A	91	£2,880.00
RCS Legal Fees	A	92	£924.69

What i want to do now is to total the above

in the footer i have =Sum([SumOfInvoice Amount])

then in a text box out side the subform i have =[Invoices Group A Totals subform].[Form]![SumOfInvoice Amount]

But what it actually displays is £210.09 (the first line of expense)

I use the above calculation all the time and it works fine, but this is the first time I am doing a Sum of a query based Sum, where am I going wrong any ideas please

Thanks

[NTC]

=[Invoices Group A Totals subform].[Form]![Footer textbox control name]

[keiath]

lol opps thanks