SELECT * FROM(

SELECT
ALL_DATES.[ALL_DATES],
V_GROUP_UNIT.[GROUP],
PT_LEVEL.[UNIT],
PT_LEVEL.[INF_YEAR],
PT_LEVEL.[INF_MONTH],
PT_LEVEL.[INF SITE MAJ],
PT_LEVEL.[SPECIF SITE],
Count(PT_LEVEL.[INF SITE MAJ]) AS [TOT/INF],
Sum(UNIT_DATA.[PT_DAYS]) AS SumOfPT_DAYS,
Sum(UNIT_DATA.[CVC_DAYS]) AS SumOfCVC_DAYS,
Avg(NHSN_BM.[CLABSI_BM]) AS AvgOfCLABSI_BM,
Avg(NHSN_BM.[CLABSI_UR_M]) AS AvgOfCLABSI_UR_M,
Sum(UNIT_DATA.[IUC_DAYS]) AS SumOfIUC_DAYS,
Avg(NHSN_BM.[CAUTI_BM]) AS AvgOfCAUTI_BM,
Avg(NHSN_BM.[CAUTI_UR_M]) AS AvgOfCAUTI_UR_M,
Sum(UNIT_DATA.[VENT_DAYS]) AS SumOfVENT_DAYS,
Avg(NHSN_BM.[VAP_BM]) AS AvgOfVAP_BM,
Avg(NHSN_BM.[VAP_UR_M]) AS AvgOfVAP_UR_M

FROM ALL_DATES

    LEFT JOIN PT_LEVEL ON
    ALL_DATES.[ALL_MONTH] = PT_LEVEL.[INF_MONTH] AND
    ALL_DATES.[ALL_YEAR] = PT_LEVEL.[INF_YEAR],

PT_LEVEL
    INNER JOIN UNIT_DATA ON
    (PT_LEVEL.[UNIT] = UNIT_DATA.[UNIT]) AND
    (PT_LEVEL.[INF_MONTH] = UNIT_DATA.[MONTH]) AND
    (PT_LEVEL.[INF_YEAR] = UNIT_DATA.[YEAR])

    INNER JOIN V_GROUP_UNIT ON
    (PT_LEVEL.[UNIT] = V_GROUP_UNIT.[UNIT])

    INNER JOIN NHSN_BM ON
    (PT_LEVEL.[UNIT] = NHSN_BM.[UNIT_LIST]) AND
    (PT_LEVEL.[INF_YEAR] = NHSN_BM.[NHSN_BM_YEAR])

GROUP BY
V_GROUP_UNIT.[GROUP],
PT_LEVEL.[UNIT],
PT_LEVEL.[INF_YEAR],
PT_LEVEL.[INF_MONTH],
PT_LEVEL.[INF SITE MAJ],
PT_LEVEL.[SPECIF SITE]

HAVING
(((PT_LEVEL.[INF SITE MAJ]) In ("VAE","BSI","UTI")) AND
((PT_LEVEL.[SPECIF SITE]) In ("CLABSI","CAUTI","VAC","IVAC","POSSIBLE VAP","PROBABLE VAP")))

ORDER BY
V_GROUP_UNIT.[GROUP],
PT_LEVEL.[UNIT],
PT_LEVEL.[INF_YEAR],
PT_LEVEL.[INF_MONTH],
PT_LEVEL.[INF SITE MAJ]

) AS QUERY1;