numeric fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
Back
Top