Numeric field overflow - error in query

[srinivasan2009]

Hi,

While Running macro i am getting error in a particular query "Numeric field overflow"

For which i am opening that query and just saving the query. and query is starts executing..

Whether any solutions ....Pl reply with your feedback

[jimatqsi]

Hi. Perhaps you have something cast as, for instance, an integer that is exceeding the acceptable value for an integer (32000 and something). Change the Cint() in your query to a Clng() and it will work.

Jim