Sum of a Query Sum in a subform

[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 Discription 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 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

 

[CJ_London]

=[Invoices Group A Totals subform].[Form]![SumOfInvoice Amount][/QUOTE]The bit in red needs to be the name of the control in the subformfooter where you have set the control source to be SumOfInvoice Amount