overflow error

[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

 

[Douglas J. Steele]

The problem is that Access assumes that the numbers integers.

Try

c = CCur(45909) * CCur(63237)

 

[Guest]

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!)





.