Overflow error

[Guest]

Hi,

I am trying to run a query that has worked in the past. Now when I run it I
get an error that says "Overflow". The query is a combination of three other
queries all of which run successfully. Does anyone know why this error
occurs?

Thanks,

 

[Guest]

There's only one practical way for us to know: Show us the SQL. Open the
query in SQL view and copy and past it here. Information on primary keys and
relationships would be a nice touch too.

However if any of the queries us a convert function, like CInt, and your
data has recently changed, that could cause a problem. For example:

Debug.Print CInt(Date()) throws a Run Time Error 6 Overflow error as Integer
only goes up to about 32,000 and today's date is 38861.

 

[John Spencer]

You can get an overflow error in a query if you divide by zero or sum
integer values that total more than 32,767 or sum values that become to
large for Access to handle.