Access Totals

[fat controller]

I am having a bit of a memory blank here - I have a report to which I have added a couple of text boxes that show numbers (2 decimal places) for each record. I am wanting to add a couple of textboxes in the report footer that total up all the values in the textboxes above, but I can't remember how to do it

I have tried adding a text box then selecting Totals from the ribbon, however that only gives the option to count records, with all the other options greyed out?

 

[pbaldy]

If the textboxes are bound to a field:

=Sum(FieldName)

If they have a calculation, you can repeat the calculation in the Sum() or use a hidden textbox with its running sum property set appropriately, and refer to that in the footer.

 

[fat controller]

I must admit that I never even considered it - I had my mind set that I should be looking at Access Totals from the ribbon.

Thank you, it works beautifully.

 

[pbaldy]

Happy to help. Just noticed I put a + in front instead of =, which I've fixed.