Insert a formatted field into your report add a function into your report change the function name to SUM In the formula put [SUM]+ [RECEIPTS] Set the initial value to 0 then select the function name SUM as the data source for the formatted field.
This will create a "total " field - unfortunatly it appears to to miss the first record out of the calculation. Which could be a bug
Well, you can set function variables at either of two levels in a Report Builder, report. The report level or the Group level - if you set it at the group level then it resets its initial value whenever the group changes - in this case it might be for every customer.
I found a way to sum fields in a report built with the wizard. It's a bit long-winded but it works.
First, create a query that sums the required fields from your source table/query. Create another query that combines your source table/query with the just-created sum query. Create a report in the wizard based on this new "compound" query (my term - not official OO). Open the report in edit mode and place one formatted field control per summed field Right-mouse click on one formatted field control and choose "Form" from the pop-up Change the data source of the form from "SQL Command" to "Query" in the Content Type field of Form Properties In the Content field, select the name of your compond query. In the Properties dialog for each your formatted fields, set the Data Field to the required summed field
I built a purchase ledger report this way. I've not got much data so I'll have to see how it stands up to more data.