Rounding numbers

[Guest]

I have created a form using data from several tables. The number field
giving me rounding trouble is this: Long Interger, fixed number, set for 6
decimal places.

For instance, upon entering the number 92.89 and expecting the number to
appear as 92.890000, the number is changed to 93.000000.

Do I have the settings wrong in the table. Or, is the trouble in the form?
I would like my numbers to remain as input, carried out to 6 decimal places.
I will want to add these numbers at some point and possible do other
calculations with the numbers.

I appreciate any help. Anxious to learn.

 

[Rick B]

An INTEGER does not have decimal places.

AN INTERGER is a whole number only.

 

[Jason Rice]

The problem is the data type of "Long Integer". You need to change the
field type to a data type that can hold decimal values. Try using "Double".
"Long Integer" will always round to a whole number.

HTH