Access - add totals to a reports

Hi Frida, thanks for your query and apologies for the delay in replying.

Open your report in Design view and add a text box control to the Report Footer. It's important that you put the field here and not, say, in the page footer; the Sum function needs to use all records in the calculation and will only do so when it is in the report header or footer. Open the control's Properties, select the Data tab, and enter an expression for the text box's Control Source property such as "=Sum([myfield])". Obviously, replace "myfield" with the field from your table. Then view the report. The sum should be in place

Hope this helps!

Anthony