Access 2003

A

Allen Browne

Open your table in design view.
Select the Number field.
In the lower pane change the Field Size from Long Integer to Double.

The integer types store whole numbers only.
 
F

fredg

How to make 1.54 appear as 1.54 instead of 2.00

You are probably using a field that is set to Number datatype, Field
Size Integer or Long Integer.
An integer, by definition, cannot contain a decimal value.
Either change the Field Size property to Single or Double, or change
the field datatype to Currency, which ever is appropriate for your
needs.
 
L

lhbryant5775

Mr. Brown:

Thank you so much. I am new to access and this job and trying to impress
the boss. Thanks to you, I just did.

Many thanks.

Lucinda
 
Top