DECIMAL NUMBER

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

In the table design, at the top of the page, you have to select the data
type of your field. Select Number.

At the bottom of the page, change the "Field Size" property on the General
tab to either single or Double. Then, in the Decimal places field, select
3.

HTH
Dale
 
Dear all,
I'm trying to save number with three decimal point
in my table.The field formatted to Number--->general
number ---- > with three decimal places.But it seems,acces
do not allow me to do that,it always returned to single numeric.
Any idea how to achieve that?

Thank's before
 
If you enter 0.900, it will be stored as 0.9. You can format the field or its
control in a form or report but the value is always 0.9.
 
Thank's Duane,
My doubt is lost now
The important thing is on the report.
How they look like.
 
Thank's Duane,
My doubt is lost now
The important thing is on the report.
How they look like.
Click to expand...

Set the Format property of the Report textbox appropriately:

#.000

for example to show three decimal places.

John W. Vinson [MVP]
 
change the "Field Size" property on the General
tab to either single or Double.
Click to expand...

Or, indeed, Decimal (as name-checked in the subject of this thread).

Jamie.

--
 
Back
Top