Unwanted rounding up of numbers

[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

 

[Douglas J. Steele]

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)

 

[John Spencer (MVP)]

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.

 

[Martin]

Yes, it was set to long integer. Thanks for the help

Martin