Thanks for the response. This helps me some of the time. What I need

to

do is allow the user to either round up or down.

So, if a number is 18.3, your example would round up to 18.5 which in most

cases will work but I also need to allow the user to choose to round down

to

18.

I can't find a way to round down other than truncating like Fix or Int

which

would not work for a number such as 18.8 because I would not want to

truncate

to 18 but rather round down to 18.5. Any ideas or suggestions?

Allen Browne said:

Double the value, round the number, and half the result:

Me.[MyField] = Round(2 * Me.[MyField], 0) / 2

I need to be able to round a number either up or down in .5 increments.

The

number is in the Currency Format in Access. So, if the number is

18.3, I

need to be able to either round down to 18 or round up to 18.5.

I found the Fix and Int functions which will truncate to value of 18. I

have

tried using Round() but it just rounds to the next whole number.

Any help would be so appreciated!