Number of digits displayed

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

Guest

I have a query that displays a value as 19.635. I've tried rounding using the round function such as Round([Value],2) which rounds it to two decimal places. I don't want to round at all i want to display the value as 19.63. Any help wpuld be appreciated.
 
I have a query that displays a value as 19.635. I've tried rounding
using the round function such as Round([Value],2) which rounds it
to two decimal places. I don't want to round at all i want to
display the value as 19.63. Any help wpuld be appreciated.
Click to expand...

exp: Int([ANumber]*100)/100
 
Back
Top