Pass-thru Query to Oracle Out of Range error

C

clm

I have a pass thru query in Access97 that is going out to
Oracle 8i data:

select Deal.YEAR_NAME ||'-'|| deal.DES_NAME as Series, Sum
(pool_dist.prin_sched_bal) as PrinSchedBal,
pool_dist.determ_date
from msplat.pool_dist, msplat.pool, msplat.deal
where pool_dist.pool_id = pool.pool_id
and deal.DEAL_SEQ_ID = pool.DEAL_SEQ_ID
GROUP BY Deal.YEAR_NAME ||'-'|| deal.DES_NAME,
POOL_DIST.DETERM_DATE
HAVING (determ_date between '01-May-2004' and '25-Jun-
2004')
ORDER BY Deal.YEAR_NAME ||'-'|| deal.DES_NAME, determ_date

I can run it fine in SQL but when I try to run it in
Access97 as a pass-thru query I get a message of:
1. ODBC call failed
2. [Microsoft][ODBC driver for Oracle]Error in column
2: Numeric value out of range (#0)

Any ideas of how to get this error message to go away?
 
Top