numeric fields

J

jenhj

Can anyone tell me why suddenly numeric fields in a very simple database have
started rounding up & rounding down - ie I enter 4.25 and it displays 4.00,
1.75 displays as 2.00. I tried every combination of decimal places, format
etc but nothing seems to stop it. I've never come across this prob before
and it's friving me nuts!!
 
A

Allen Browne

Open your table in design view.
Select the numeric field.
In the lower pane, change the Field Size from to Double.

The integer types can only store whole numbers.

The format and number of decimal places only affects how the number is
displayed, not how it is stored.
 
Top