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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Assuming your field name was NumOfDaysOld, you would use:

=Sum(Abs([NumOfDaysOld] >180))
 
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...
 

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

A03 - count in report footer gives me #Error? 0
Access Dcount (multiple criteria) 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Creating Totals for each COLUMN in a report 1
Counting Records in a report 1
Counting records in group not working - Access 2007/WinXP 4
sort by sum of a field 1
How to Sum Total cost field in report 2

Back
Top