counting a field in a report to show total # past the set #

J

JamieM

I need to count a field where the result would show the number of records
that are over a certain # of days. For example:

Field Name: # of days old

want a total # that shows how many records are over 180 days. I tried the
following: =count [# of days old]>180. I know there is 1 record that is over
180 days; however, the total shows -1.
 
D

Duane Hookom

Assuming your field name was NumOfDaysOld, you would use:

=Sum(Abs([NumOfDaysOld] >180))
 
J

JamieM

Thanks! It worked.

Duane Hookom said:
Assuming your field name was NumOfDaysOld, you would use:

=Sum(Abs([NumOfDaysOld] >180))

--
Duane Hookom
MS Access MVP

JamieM said:
I need to count a field where the result would show the number of records
that are over a certain # of days. For example:

Field Name: # of days old

want a total # that shows how many records are over 180 days. I tried the
following: =count [# of days old]>180. I know there is 1 record that is
over
180 days; however, the total shows -1.
Click to expand...
Click to expand...
 
Top