Calculate report footer

[ferde]

I have created a query which gives me the number of patients admitted in a
given period and it tells me what the patients disposition is on discharge.
Can someone please tell me how I would get my report footer calculation to
only give me the total number of admits who were discharged alive. Thank you
in advance for your help.

NumberAdmits DischargeDisposition
10 alive
5 dead
2 alive
14 alive
10 dead

 

[boblarson]

I would put a text box on the report footer and use:

=Sum(IIf([DischargeDisposition]="alive",1,0))

 

[ferde]

Thank you ... I appreciate your help

I would put a text box on the report footer and use:

=Sum(IIf([DischargeDisposition]="alive",1,0))
--
Bob Larson
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

I have created a query which gives me the number of patients admitted in a
given period and it tells me what the patients disposition is on discharge.
Can someone please tell me how I would get my report footer calculation to
only give me the total number of admits who were discharged alive. Thank you
in advance for your help.

NumberAdmits DischargeDisposition
10 alive
5 dead
2 alive
14 alive
10 dead