Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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
 
Back
Top