Round function in queue

J

Jerald Leung

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
 
A

Allen Browne

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

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