Totalling calculated fields (1 Viewer)

[Nicola]

Hi

I have a report which has 'Textbox1' in the group footer, 'Textbox1' is a calculated field.

In the report footer I would like to add together all of the 'Textbox1' fields.

I have tried to use sum([Textbox1]) but this results in Access prompting me fo rthe value of 'Textbox1'.

Can anyone help?

Thanks.

 

[BoroLee]

Is TextBox1 the name of the box with the calculated field in it, or the name of its label ????

Maybe, you should try using the Sum function in your group footer.

HTH,
Lee.

 

[Nicola]

I've cracked it!

I added a calculated field to the underlying query, then in the report I was able to 'Sum' this calculated field in the report footer.

Nicola