Access Overflow

[starflt1701]

Can someone please tell me what's going on? I have a rather complicated query which draws information from many tables, including ODBC, and involves some calculations. I recently began getting an "Overflow" error when running the query. After hours of tearing the query apart, I found the culprit. One of my calculations involves the CINT function to return a whloe integer value. When I leave this function in the equation, the query overflows. When I remove the CINT from the equation, it works fine. I have been using this query with the CINT function for months with no problems until the last couple weeks. Can anyone help?

 

[dvrobin]

Since CINT returns an integer value, it can only handle a number up to 32,767. If your value will be greater than that, then you will have an overflow problem. I'm not sure if CLNG works in SQL, but that would be the VB equivalent of what you probably need. CLNG will convert to long which can hold a number up to 2,147,483,647.
Dave Robinder, MCSD
Programmer
Colorado DataScapes
Colorado Springs, CO
(719) 328-1111

 

[starflt1701]

Thanks. That helps explain what is going on. I will try CLNG.