how do I enter .015 in Access

[billseward]

In access I'm trying to * 1000 by.015% and it is not working

 

[Graham R Seach]

Bill,

Debug.Print 100 * 0.000015
....or...
Debug.Print 100 * (0.015 / 1000)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Graham R Seach]

Bill,

Oops! Sorry - too many zeros.

Debug.Print 100 * 0.00015
....or...
Debug.Print 100 * (0.015 / 100)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[John Vinson]

In access I'm trying to * 1000 by.015% and it is not working

My guess is that you're doing something wrong.

Please explain where and how you are trying to do the multiplication
and in what way it's not working. You are working on the assumption
that 0.015% is equal to 0.00015, right?


John W. Vinson[MVP]

 

[SJ McAbney]

You are probably trying to assign this .015 to a Byte, Integer, or Long
variable type.