Rounding numbers

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

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.
 
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
 
Back
Top