Rookie Question about Field Type

G

GeorgeB

I am trying to define a field that will accept numbers, with up to 2 places
after the decimal. No matter how I define the field, when I enter 4.70, the
cell rounds up to 5. I know this is a simple matter, but I'm stuck
 
A

Allen Browne

Open your table in design view.
Select the problem field.
In the lower pane, set the Field Size to Double.

The Integer types accept only whole numbers, regardless of how you display
them.
 
Top