Overflow Error

  • Thread starter Thread starter Mark C via AccessMonster.com
  • Start date Start date
M

Mark C via AccessMonster.com

I have a number that needs to calculate very large numbers.

i.e. 44000011 x 220

I get an overflow error when it tries to calculate this.

The calc is done in code.

Any ideas? I have tried ever data type for the variable that gets this total.


TIA
 
Typecast to a double (or perhaps currency), e.g.:
? CDbl(44000011) * 220
? CCur(44000011) * 220
 
Thanks! that worked like a charm!

Allen said:
Typecast to a double (or perhaps currency), e.g.:
? CDbl(44000011) * 220
? CCur(44000011) * 220
I have a number that needs to calculate very large numbers.
Click to expand...
[quoted text clipped - 6 lines]
Any ideas? I have tried ever data type for the variable that gets this
total.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why am I getting an overflow error in this simple query? 3
Access Overflow error 3
Overflow error on calculate field in query - Help Please 1
Docmd.Movesize 6
Numeric Overflow Error 4
Help on Code Snippet Error {Val function} 6
overflow error 1
Overflow error when appending data to SQL from Access 1

Back
Top