Count Expression in a Report’s Unbound TextBox

[Bill6868]

On a report I have a field named “Respite” – any client who receives respite care gets a “Y” in the field. This is not a yes/no field it is a text field. In the report footer I need a count of all the “Y’s” but I can’t seem to get the syntax correct in the unbound textbox expression. The report’s query is embedded and contains fields from three tables. The table containing the field “Respite” is from tblClients.

I’ve tried Count and DCount but no luck.

Any suggestions would be most appreciated.

Bill

 

[dhookom]

Use the expression:

=Sum(Abs([Respite]="Y"))

Duane
Hook'D on Access
MS Access MVP

 

[Bill6868]

Thanks Duane - much appreciated.

Bill