Overflow Error

[bigdavidt]

Good afternoon.

I have been working on a query that draws on two subqueries. Each of the subqueries draws on three tables and another query that draws from three small tables. My subqueries seem to work, and my main query seems to work, but when I try to run my report I get a message box that says 'Overflow'. Does anybody have any ideas on what steps I should take?

I am using Access 2003, with an outside table from Hyperion.

Thank you in advance.

 

[dhookom]

An overflow is generally caused by a divide by zero. If you are performing any division that might cause this, use an expression like:
IIf([expr1]= 0 , 0 , [expr2]/[expr1])

Duane
Hook'D on Access
MS Access MVP