Total counting records

[Rick_W_Johnson_(Guest)]

Is there a way to count records, but only if the value is not 0.____For example. sorting by Date, I have values from a record.____10/01/04 has three records with values of 0, 25, and 56. I would want this days count to be 2__10/02/04 has 4 records with values of 0, 24, 0, 0. I would want this days count to be 1. __ __ __I know someone knows how to do this, so I thank you in advance.__Rick Johnson____Ver10.1

[Randall_Warden_(Guest)]

Use a condition in your total field where it has to be greater than zero (e.g. FIELD > 0).

[Rick_W_Johnson_(Guest)]

Thank You. I have done thousands of totals in my day, but never once had I seen that condition field in the total creation dialogue. It works perfecto........__Rick Johnson