Count based on value of text field

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I would like my report section to perform a count based
on the value of a text field called "Status".

For example, I would like to create a field in the
section footer that is a count of all the records in that
section where [Status] = "Expired".

Is there a way to do this?
Count([Status]="Expired") is not working.

Thanks!
--Laura
 
Works great! Thanks! --Laura
-----Original Message-----
Try:
=Abs(Sum([Status] = "Expired"))

--
Duane Hookom
MS Access MVP


Laura said:
I would like my report section to perform a count based
on the value of a text field called "Status".

For example, I would like to create a field in the
section footer that is a count of all the records in that
section where [Status] = "Expired".

Is there a way to do this?
Count([Status]="Expired") is not working.

Thanks!
--Laura
Click to expand...


.
Click to expand...
 
Back
Top