access database training - Inserting Totals in a Report ( Access )

Colin,

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
No - This Item is not a running total
Over Group - This Item is a running total which will reset to zero with each new group value
Over All - This Item is a running total which will total over the whole report

Let me know if this fixes the problem.

Regards, Rich

Hi Colin

Are you entering the actual field name in the formula.

ie: =sum([revenue])

unless you do this, access does not know what data to sum.

"Exp" means expression. It is the default placeholder for this formula

Is the [exp] a field name from the report?

If not you need to replace the word exp with the name of the field to be calculated

eg:

To add all the [Quantity] values write it as

=Sum([Quantity])