G
Guest
I need to be able to round values to this specification using vba in Access2003
£0.005 or less is disregarded, we only look at the third decimal place.
If it is 5 or less round down.
If it is 6 or more round up.
For example,
£67.5558 would be £67.55.
£67.5568 would be £67.56.
ive been using the round function but it rounds up at 5 and down at 4 but i
need it to round up at 6 and down at 5.
Can anyone help please??
£0.005 or less is disregarded, we only look at the third decimal place.
If it is 5 or less round down.
If it is 6 or more round up.
For example,
£67.5558 would be £67.55.
£67.5568 would be £67.56.
ive been using the round function but it rounds up at 5 and down at 4 but i
need it to round up at 6 and down at 5.
Can anyone help please??