Calculate report footer

  • Thread starter Thread starter ferde
  • Start date Start date
F

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
 
I would put a text box on the report footer and use:

=Sum(IIf([DischargeDisposition]="alive",1,0))
 
Thank you ... I appreciate your help

boblarson said:
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

__________________________________


ferde said:
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
Click to expand...
Click to expand...
 
Back
Top