total combo box selections

[nanny]

Good morning all,
I have a form that lets you choose a patient's diagnosis from a combo box. I am now trying to total each diagnosis on a report. I need some help communicating to the computer what I want. I have tried =Count(IIF([HospiceDiagnosis], "COPD")) and multiple variations of that. Any help is appreciated.
Thanks
Nanny

 

[pbaldy]

Try this if I'm interpreting correctly:

=Sum(IIf([HospiceDiagnosis] = "COPD", 1, 0))

 

[nanny]

It still does not work. When I use the expression builder, should I be selecting [HospiceDiagnosis] from the table, query or form???
Thanks,
Nanny

 

[pbaldy]

I hardly ever use that anymore. What's expected there is the name of a field in the data, so I suppose table or query, whichever is the source of the report. Make sure that the field contains that text value too, rather than an ID.