Access 2003

[Guest]

How to make 1.54 appear as 1.54 instead of 2.00

 

[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.

 

[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.

 

[Guest]

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