Reports

  • Thread starter Thread starter johnt
  • Start date Start date
J

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.
 
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
 
Back
Top