Rounding numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elizabeth - 28 Apr 2005 22:02 GMT

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.

Signature

Elizabeth

Reply to this Message

Rick B - 28 Apr 2005 22:06 GMT

An INTEGER does not have decimal places.

AN INTERGER is a whole number only.

Signature

Rick B

> 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
[quoted text clipped - 9 lines]
>
> I appreciate any help. Anxious to learn.

Reply to this Message

Jason Rice - 28 Apr 2005 22:07 GMT

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

Signature

Jason Rice

>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
[quoted text clipped - 12 lines]
>
> I appreciate any help. Anxious to learn.

Reply to this Message