Grand Totals

[ewong1]

I have an existing report that shows me the following items(not exact names):

Date, Tank, Beginning Gauge, Ending Gauge, Difference, Out of Range

I currently have the db querying a list of records by date showing me the difference between the beginning gauge and the ending gauge. If the difference between the beginning and ending gauges is more than .125" then it is considered out of range. the Out of Range field lists how far out of range the gauge is. Example Data:

03/15/05, 6120, 34'5"4, 33'2"4, -15(inches), 14.875(inches out of range)
03/15/05, 3085, 34'5"4, 34'5"4, 0, 0

Is it possible for me to show a grand total number of records in the view at the bottom of the report, as well as a grand total number of records that have values "out of range"? The data above would return 1 tank out of range, 2 total tanks. Hopefully I've made myself clear. Let me know if it is possible. Thanks!

 

[Rich]

=Count(*) in an unbound textbox in the report footer will give a count of the total records and a hidden conditional textbox in the detail section using the RunningSum property will give a count of the out of range records