Number formatting

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Presently in my formula I am using

sngIncr = (Me.TL - Me.MIN) / 17

How should I modify the formula (or what command should I
use) that would round of the number so no decimals show.

Additionally, is there a way that I can round up to the
nearest number ending in 5. E.g. if the results of mu
formula is 3072, I would like 3075 to be displayed.

Your assitance is appreciated.

Rob
-----Original Message-----
When you click, the actual value of the field will show. If you want the
value to be in whole numbers, then enter it into the field as whole numbers.
If it is a calculated field, then you will have to round the results.

The format is simply a way to change the way a number looks. The underlying
number is still the same.

Rick B


I have created a form and set the format of the fields to
currency with a 0 decimal places.

When I go into form view I see the value as set e.g. $1,234
When I click in the field the view changes to $1,234.8366

What properties do I set so the display stays at $1,234

Any helps would be appreciated.

Rob


.
Click to expand...
..
 
Presently in my formula I am using

sngIncr = (Me.TL - Me.MIN) / 17

How should I modify the formula (or what command should I
use) that would round of the number so no decimals show.
Click to expand...

sngIncr = Fix((Me.TL - Me.MIN) / 17)
Additionally, is there a way that I can round up to the
nearest number ending in 5. E.g. if the results of mu
formula is 3072, I would like 3075 to be displayed.
Click to expand...

sngIncr = 5*Fix((Me.TL - Me.MIN) / 85)
 
Back
Top