If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fractional Number Value in a field
I'm trying to add a field that would have a fractional number value. For example, 5.5 or 3.5. The problem is that the field would round up to the nearest value after I tab over to the next field. So instead of 5.5 it would default to 6.0. How can I keep that from happening? I've used the "General Number", "Standard", and "Fixed" format using either 1 or 2 decimals. I have the table in the same settings too.
Any suggestions would be greatly appreciated. Thanks, maria |
#2
|
|||
|
|||
Fractional Number Value in a field
On Mon, 21 Jun 2004 15:13:01 -0700, Maria K wrote:
I'm trying to add a field that would have a fractional number value. For example, 5.5 or 3.5. The problem is that the field would round up to the nearest value after I tab over to the next field. So instead of 5.5 it would default to 6.0. How can I keep that from happening? I've used the "General Number", "Standard", and "Fixed" format using either 1 or 2 decimals. I have the table in the same settings too. Any suggestions would be greatly appreciated. Thanks, maria The Field Number size is an Integer or Long. Change it to a size that supports decimals, i.e. double, currency, etc. By definition, an integer cannot have a decimal value. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|