Rounding/signficant figures

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I need to be able to report values rounded or rather
reported to two significant figures, for example, 15.43
becomes 15 , 34645 becomes 35000, and 0.454 becomes 0.45.

the inbuilt mathmatical functions within access dont seem
to be able to do what i want; round, Int, Cint etc

Can someone please advise me how to solve this please..

Regards

Pat
 
I usually nest a format function inside a val function.
Following your example

trunc_value: Val(Format([value],"0.0E+00"))
 
Back
Top