overflow error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using Access 2000. I have the simple lines of code
below. Everytime this
code runs I get an overflow error?
Is this a bug in Access 2000? The result of the below
calculation is
2903147433 and I thought the range of size for currency
was -922,337,203,685,477.5808 to
922,337,203,685,477.5807. Any help would be
appreciated!

Dim c As Currency
c = 45909 * 63237
 
The problem is that Access assumes that the numbers integers.

Try

c = CCur(45909) * CCur(63237)
 
Thanks!
-----Original Message-----
The problem is that Access assumes that the numbers integers.

Try

c = CCur(45909) * CCur(63237)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





.
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

overflow error 1
Overflow error 6 3
Access Overflow error 3
public function always returns zero 2
Overflow Error 6
Network Drive Free Space 9
"Overflow Error" - need help please. 7
Overflow error when using FOR loop 2

Back
Top