Round function in queue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
So you want to ignore the 3rd digit after the decimal, and round everything
down.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top