G
Guest
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
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