Count based on value of text field

[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

 

[Duane Hookom]

Try:
=Abs(Sum([Status] = "Expired"))

 

[Laura]

Works great! Thanks! --Laura

-----Original Message-----
Try:
=Abs(Sum([Status] = "Expired"))

--
Duane Hookom
MS Access MVP

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

.