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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top