Bobby
asked on
Access 2003 query, round down to nearest 5 cents
How do I get prices to round down to nearest nickle without using code? Id like to do it from with the query. Here's what Ive tried but it throws the price totally out of whack:
Round(20*products.price+in ventorypro file.estsh ipcost,0)/ 20
Thanks.
Round(20*products.price+in
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No Woo Hoo, as this code doesn't round down but rounds to the nearest even.
Further, Round is buggy.
To round down, you need this:
ListPrice: Int(20*(products.price+inv entoryprof ile.estshi pcost))/20
If you have a serious need for rounding, study the options here:
Rounding values up, down, by 4/5, or to significant figures
/gustav
Further, Round is buggy.
To round down, you need this:
ListPrice: Int(20*(products.price+inv
If you have a serious need for rounding, study the options here:
Rounding values up, down, by 4/5, or to significant figures
/gustav
ASKER