TRANSFORM SUM(STH_PAYMENT.PAY_SUM)
SELECT i.INS_REG_NUM, STH_PAYMENT.PAY_INSURER_NAME, PAYDC_KBK, pd.PAYDC_KBK as PAY_SUM_TOTAL
FROM STH_PAY_DOCUMENT AS pd INNER JOIN (STH_PAYMENT INNER JOIN STH_INSURER AS i ON STH_PAYMENT.INS_ID=i.INS_ID) ON STH_PAYMENT.PAYDC_ID=pd.PAYDC_ID
WHERE (((STH_PAYMENT.PAY_BANK_OUT)>=# 2 / 12 / 2010 # And (STH_PAYMENT.PAY_BANK_OUT)<=# 2 / 17 / 2010 #))
GROUP BY i.INS_REG_NUM, STH_PAYMENT.PAY_INSURER_NAME, pd.PAYDC_KBK
PIVOT STH_PAY_DOCUMENT.KBK