Num & Den Counts

[Andy]

My Query is laid out as follows in order to give me the Denominator:

Field:Hospital
Table: BNH_HF_PT_LVL
Total:Group By

Field:Measures
Table: BNH_HF_PT_LVL
Total:Group By
Criteria: "Discharge instructions"

Fieldischarge Denominator: Measure Category AssignmentTable: BNH_HF_PT_LVL
Total:Count

Fieldischarge Date
Table: BNH_HF_PT_LVL
Total:Where
Criteria: Between #01/01/2006# And #03/31/2006#

Field:Measure Category Assignment
Table: BNH_HF_PT_LVL
Total:Where
Criteria: "In Measure Population" Or "In Numerator Population"

Do I have to create a separate Query to get the Numerator as I have done
below in order to make this work or may I do this all in one query. If so
how?

Field:Hospital
Table: BNH_HF_PT_LVL
Total:Group By

Field:Measures
Table: BNH_HF_PT_LVL
Total:Group By
Criteria: "Discharge instructions"

Fieldischarge Denominator: Measure Category AssignmentTable: BNH_HF_PT_LVL
Total:Count

Fieldischarge Date
Table: BNH_HF_PT_LVL
Total:Where
Criteria: Between #01/01/2006# And #03/31/2006#

Field:Measure Category Assignment
Table: BNH_HF_PT_LVL
Total:Where
Criteria: "In Numerator Population"

Thanks,
Andy

 

[Andy]

I answered my own question by building the following:

Numerator: Sum((IIf([Measure Category Assignment]="In Numerator
Population",1,0)))

Thanks to the other threads for helping me figure this out!!!!!