By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,628 Members | 1,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,628 IT Pros & Developers. It's quick & easy.

Numeric field overflow - error in query

P: 4
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
Jan 29 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,221
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
Jan 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.