I am having various issues with rounding across my db.
A lot of the numbers I deal with are in currency format. Both the controls and the fields within the tables are set to currency, yet it appears it is still rounding to the .0001 place (roughly) and is resulting in some interesting numbers.
I looked in the Round() function, but that rounds to the nearest whole dollar up and down. Per my boss, he wants to round to the nearest tenth and always up like excels RoundUp function.
So items like $10.01 go to $10.10 and $10.11 go to $10.20 etc. etc.
I am reading:
Would I just use the Int function? And to get to the tenth, would it be like Int(-10 * [myfield]) / -10?
A lot of the numbers I deal with are in currency format. Both the controls and the fields within the tables are set to currency, yet it appears it is still rounding to the .0001 place (roughly) and is resulting in some interesting numbers.
I looked in the Round() function, but that rounds to the nearest whole dollar up and down. Per my boss, he wants to round to the nearest tenth and always up like excels RoundUp function.
So items like $10.01 go to $10.10 and $10.11 go to $10.20 etc. etc.
I am reading:
Microsoft Access tips: Rounding numbers in Access
How to round numbers in Microsoft Access: to the nearest number, rounding up, rounding down, to the nearest 5 cents, rounding dates and times, bankers rounding, and handling floating point errors
www.allenbrowne.com
Would I just use the Int function? And to get to the tenth, would it be like Int(-10 * [myfield]) / -10?