Round function in queue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerald Leung - 28 Nov 2005 06:44 GMT

How can I use the Round() funciton in queue but not round up the decimal place.
E.g. I would like to round up 3.456 to 3.45 instead of 3.46.

Thanks for help.

Jerald

Reply to this Message

Allen Browne - 28 Nov 2005 08:05 GMT

So you want to ignore the 3rd digit after the decimal, and round everything
down.

Int() does that, e.g.:
Int(100 * [Field1]) / 100

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How can I use the Round() funciton in queue but not round up the decimal
> place.
[quoted text clipped - 3 lines]
>
> Jerald

Reply to this Message