[RESOLVED] Arithmatic Overflow Error On DB2 Query

[Hack]

One of the folks I work with runs a lot of queries against DB2 tables. He is using MS Access 2000 and linking to the DB2 tables.

On this particular query, he is receiving an Arthmatic Over Flow error and has asked if I could provide some possibilities with respect to why it is occuring. I image there are a number of questions that need to be answered but, I don't even know what the questions are. Here is the query

SELECT CDFA0000.CTFS0010.FACILITY_CD, CDFA0000.CTFS0010.RECORD_TYPE, 
CDFA0000.CTFS0020.FEE_BASED_IND, 
Sum((CDFA0000.CTFS0010.CONTRACT_CHARGES*
(CDFA0000.CTFS0020.COVERED_CHARGES/CDFA0000.CTFS0010.COVERED_CHARGES))) AS Contract_chg, CDFA0000.CTFS0020.PROCEDURE_CTG, 
CDFA0000.CTFS0020.REV_OFF_SUR_IND
FROM CDFA0000.CTFS0010 INNER JOIN CDFA0000.CTFS0020 ON 
(CDFA0000.CTFS0010.FRONT_SHEET_QTR = 
CDFA0000.CTFS0020.FRONT_SHEET_QTR) AND 
(CDFA0000.CTFS0010.RECORD_ID = CDFA0000.CTFS0020.RECORD_ID) AND 
(CDFA0000.CTFS0010.FACILITY_CD = CDFA0000.CTFS0020.FACILITY_CD)
WHERE
CDFA0000.CTFS0010.ADMISSION_DT Between '10/01/2004' and '06/30/2005' And
CDFA0000.CTFS0010.RECORD_TYPE In ('NP') AND
CDFA0000.CTFS0010.FYE_END_DT ='09/30/2005' AND
CDFA0000.CTFS0010.FACILITY_CD='00179' AND 
CDFA0000.CTFS0010.FRONT_SHEET_QTR='53' AND
CDFA0000.CTFS0010.INPAT_OUTPAT_IND='O' AND
CDFA0000.CTFS0010.COVERED_CHARGES<>0
GROUP BY CDFA0000.CTFS0010.FACILITY_CD, CDFA0000.CTFS0010.RECORD_TYPE, CDFA0000.CTFS0020.FEE_BASED_IND, 
CDFA0000.CTFS0020.PROCEDURE_CTG, CDFA0000.CTFS0020.REV_OFF_SUR_IND

Here is the error message: