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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One to Many Relationship 2
# Error when no data 4
Calculate beginning balance, but print details on report 3
Running Sum + initial value 3
Total different groups 4
Running balance and balance b/f 3
Summary Report 2
Programming some nuances 1

Back
Top