format number

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

Guest

Hi,

I has a field that has been set by addition from a number of fields. The
data has been set to general number with two decimals. My problem is that
the number is shown with two decimals but the number has been round i.e.
24.35 became 24.00
24.65 became 25.00.

How do I fix this?? Please help

many thanks
 
Open the table in design view.
Select the problem field.
In the lower pane, change the Field Size to:
Double

The integer types can only store whole numbers, regardless of how you format
and display them.
 
Back
Top