Report Summing

[boblovesyousomuch]

Hi,

I create a report by using a query, in the footer i have placed a text box that i want to sum all the values of the balance column.

ie
£5.00
£2.00
-----
£7.00

I have set the control source to =Sum([SumOfDO_Balance]) but all I get is #error.

Any help will be greatly appreciated.

Carl

 

[GingerR]

is your 'balance' column calculated directly on the report, and is not part of the underlying query? if so, try putting the calculation in the query.

 

[boblovesyousomuch]

The query i use uses queries other queries and I pull the balance from that. I can't amend the query unfortunatley as it is used somewhere else. What should I do???

 

[GingerR]

either write another query, or copy the sql string from the query you are using, paste it into the report's Record Sourse (instead of a query name). click on the BUILD Button to the right (the button with the three dots on it) then add this calculated field to this query. bring that field down in to your report in the detail section, then sum it in the report footer.