G
Guest
In access I'm trying to * 1000 by.015% and it is not working
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
G
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
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
J
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]
G
Guest
You are probably trying to assign this .015 to a Byte, Integer, or Long
variable type.
variable type.