Number field type

[Faio]

Hi,

I am quite new using Access so how could you use the number field so that
when entering 1.2303 into a field called weight it will display it exactly
and not round it off?

Any help?

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi,

you cannot use Integer or Long Integer number types.

Try Single or Double, depending on the precision you need.


Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[Wayne Morgan]

When you enter a field type of Number, check the sheet at the bottom of the
table design mode. You should be able to pick the type of number there in
the Field Size box. By default, it is probably set for Long Integer.

 

[Faio]

Thanks,

Double work fine and I have not tried Single. ANyway thanks for your help.