Round values up and down

[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??

 

[Guest]

I posted before but I'm not sure if the answer went through. I'll try again

IIF([FieldName] =
Round([FieldName],3),Round([FieldName],2),Round([FieldName]-0.001,2))

I tried few cases and it worked, but there might be a case that I didn't check

 

[Guest]

Try something like

IIF(aaa =
Round([YourNumber],3),Round([YourNumber],2),Round([YourNumber]-0.001,2))

I tried few cases and it worked but mybe I didn't cover all cases

 

[Guest]

Many thanks, seems to be doing what i want it too.

Once again thanks.

I posted before but I'm not sure if the answer went through. I'll try again

IIF([FieldName] =
Round([FieldName],3),Round([FieldName],2),Round([FieldName]-0.001,2))

I tried few cases and it worked, but there might be a case that I didn't check

--
Good Luck
BS"D

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??