Sum totals and sub totals in report

[Rogeman]

Hello all,

I am trying to show the total amount of "members payments" made in a report, as entered on a table.
The Report only contains "Todays" entries today, the total of these entries I am able to show by (=Sum([Paid]).
How can I also show the Complete "Totals" of all the entries in another textbox?


the table contains names, addresses etc.,I only have one column showing the paid amounts by each person.

Thanks in advance

Roger

[pbaldy]

Try a DSum() formula.