How to calculate hide records while calculate their totals

  • Thread starter Thread starter Ty Archer
  • Start date Start date
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.
 
You can use code in the On Format event like
Cancel = Me.txtSpecificDate>=#3/1/2003#
 
Back
Top