Decimal Places

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

Guest

I have numeric data that I would like to always show with a certain number of decimal places. But, when I get whole numbers I do not get the decimal point with zero's after it

Can I make it show a certain number of decimal places

Thanks

Josh
 
Nevermind, I had my number set to General Number and that caused the Decimal places not to show.

Thanks anyway.

Josh
 
Yes, depend on you are working in tables or queries.
Just go to the design view and find out the
property "Format or Decimal places" to specify what you
want to show (ie. 1 or 2 decimal places).
Hope this helps.
jenny
-----Original Message-----
I have numeric data that I would like to always show
Click to expand...
with a certain number of decimal places. But, when I get
whole numbers I do not get the decimal point with zero's
after it.
 
format (num, "####.00")
-----Original Message-----
I have numeric data that I would like to always show with
Click to expand...
a certain number of decimal places. But, when I get whole
numbers I do not get the decimal point with zero's after
it.
 
format (num, "####.00")

a certain number of decimal places. But, when I get whole
numbers I do not get the decimal point with zero's after
it.
Click to expand...

Just be sure that the datatype of your field allows decimal places!
The default Number datatype is Long Integer, which *is* an integer -
i.e. a whole number with no decimals.

You must use Float or Double to allow decimal places in a Number type
field; or you may want to use a Currency datatype rather than a
Number: it has exactly four (no more, no fewer) decimals and does not
have roundoff error, which can be a hassle with Float and Double.
 
Back
Top