Reports

[johnt]

I would like to create a report based on dates collected from a query.
The report needs to display totals for a 'Deposit' field for the
included dates, but also the entire total for the 'Deposit' field. Any
attempts only show the total for the dates range.

 

[Steve Schapel]

John,

One option would be to put an unbound textbox on your report, and set
its controlsource property to the equivalent of...
=DSum("[Deposit]","NameOfYourTable")

- Steve Schapel, Microsoft Access MVP