Number Field Automatically Rounds in Error

[dbain30]

I have a table where at the end of the process, after the item is
outstanding for a period of time, an amount must be entered into one of
the fields.

I originally set this up as follows:
Field Name: Premium Amount
Data Type: Number
Field Size: Long Integer
Format: ##,###.##
Decimal: 2 Places

The problem that I'm having is that it's rounding every number to the
nearest dollar and I really need for the cents to be accurate as well.

I've changed the properties to various options and so far it comes back
with the same results.

I'm using Access 97.

Any suggestions would be appreciated! This seems so simple and for
whatever reason I'm frustrated at trying to find an answer.

 

[Douglas J. Steele]

A Long Integer cannot store decimal points: that's one of the
characteristics of integers.

Since you're dealing with money, you're best off changing the Date Type to
Currency. Otherwise, you need to change the Field Size to Single or Double.

 

[Joseph Meehan]

I have a table where at the end of the process, after the item is
outstanding for a period of time, an amount must be entered into one
of the fields.

I originally set this up as follows:
Field Name: Premium Amount
Data Type: Number
Field Size: Long Integer

Bingo! Integer's are .. well they are integers and integers are whole
numbers no decimals. Try to change to single or double number types.