Unwanted rounding up of numbers

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi,

In a table I have created the numeric details are rounded
up or down i.e 12.34 will show as 12.00 and 34.67 will
show as 35.00. How do I prevent this happening? I would
like the exact numbers entered to be shown in the table,
report etc.

Many thanks in advance
 
Sounds as though you might have inadvertently left your field type as Long
Integer (the default numeric type), rather than one of the numeric types
that can store decimals (Single or Double)
 
You have set the number field's type as Integer or Long integer. Integers only
store whole numbers (no decimal portion)

Open your table and set the field size to Single or Double or Decimal. OR change
the Field Type to Currency.
 
Back
Top