DECIMAL NUMBER

[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

 

[New_Access]

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

 

[New_Access]

Dear Dale,
3 decimal places doesn't return 0.9 to 0.900 in my table.
Why? Any idea?

 

[Duane Hookom]

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.

 

[New_Access]

Thank's Duane,
My doubt is lost now
The important thing is on the report.
How they look like.

 

[John W. Vinson]

Thank's Duane,
My doubt is lost now
The important thing is on the report.
How they look like.

Set the Format property of the Report textbox appropriately:

#.000

for example to show three decimal places.

John W. Vinson [MVP]

 

[Jamie Collins]

change the "Field Size" property on the General
tab to either single or Double.

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

Jamie.

--