Rounddown Numbers

  • Thread starter Thread starter CHIN
  • Start date Start date
C

CHIN

Hi, to all kind helpers,
How do I rounddown a number to 2 places of
decimal? Using "Currency' and then "fixed"
in "Properties" section of the TextBox shows a roundup of
2 decimal places. For example, 243.236 is displayed as
243.24, but I wanted only this 243.23.
On the TexBox, I tried this formaula =Roundown
([fieldname],2)", it displays " No function ddefined".
Disappointingly , I use the same formaula to
create an expresion field in the Query Grid, but still
cannot get a rounddown number. I also tried using =Trunc
([FieldName],2)", but it does not work either.
I appreciate your help.
 
Assume Number contains the number you want to round:

RoundedNumber = Int(Number * 100) / 100
 
Chin,

Have a look at the fix and int functions. With a bit of
manipulation of your values these will do what you want.

Not as nearly as nice as the roundup/down functions in
Excel.

HTH,

Terry
 
Back
Top