How to calculate hide records while calculate their totals

T

Ty Archer

I am looking to create a report that shows records for a
specific date (ie from Jan - Mar), however, I want to
calculate an overall total even for those records not
shown on the report. Therefore even though the records
from May - Dec will be hidden in the detail section, the
overall total will include the hidden data. Thanks very
much.
 
D

Duane Hookom

You can use code in the On Format event like
Cancel = Me.txtSpecificDate>=#3/1/2003#
 

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

Calculating a Total for each record source in a Report 1
Calculating percentage from grouped report 3
DLookUp Error is frustrating!!! 0
Can't calculate Grand Total of several other expressions 1
Unusual Calculation in Report Header 3
Trouble calculating in a report b/c of data structure 0
Calculate total amt due on an invoice. 9
Calculating group totals for multiple var's. 1

Top