G
Guest
when im adding a number eg 5.99 why does it show up as 6.00, i was told when im setting up the table and i put data in as numbers that i have to alter something, but what
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
GVaught
Field size and format. I created a number datatype field. Changed to Single
| Fixed | Decimal Places: 2 and typed in 5.99 it stayed. However, before I
changed the datatype it was Number | Long Integer and although I typed in
5.99 it changed it to 6. Any adjustments I made did not change the value to
5.99, it changed it to 6.00 instead.
Once I changed to the Single | Fixed etc and retyped the value 5.99; the
5.99 stayed.
alter something, but what
| Fixed | Decimal Places: 2 and typed in 5.99 it stayed. However, before I
changed the datatype it was Number | Long Integer and although I typed in
5.99 it changed it to 6. Any adjustments I made did not change the value to
5.99, it changed it to 6.00 instead.
Once I changed to the Single | Fixed etc and retyped the value 5.99; the
5.99 stayed.
when im setting up the table and i put data in as numbers that i have tojokay said:when im adding a number eg 5.99 why does it show up as 6.00, i was told
alter something, but what
P
PC Datasheet
Double check again!
It's impossible to get 6.00 when the data type is set to Number|Long Integer!
It's impossible to get 6.00 when the data type is set to Number|Long Integer!
T
tina
PC is correct, it's impossible for the system to save the decimal value .00
in the field. but you can "see" the .00 if your field properties are set a
certain way. if you set the data type as Number, the field size as Long
Integer, the format as Fixed or Standard, and the decimal places as 2 - if
you type 6, you will see 6.00; if you type 5.99 you will see 6.00, etc.
just remember that Format and Decimal Places properties affect how the data
looks, *not* the underlying values saved in the table.
hth
in the field. but you can "see" the .00 if your field properties are set a
certain way. if you set the data type as Number, the field size as Long
Integer, the format as Fixed or Standard, and the decimal places as 2 - if
you type 6, you will see 6.00; if you type 5.99 you will see 6.00, etc.
just remember that Format and Decimal Places properties affect how the data
looks, *not* the underlying values saved in the table.
hth
P
PC Datasheet
Tina,
Thanks for the support!
Just to add to what you said, if the data type is long integer and if you type
in 5.99 the stored value is 6 (not 5.99) and if the format is Fixed or Standard
and the decimal places is 2, you will see 6.00.
Steve
PC Datasheet
Thanks for the support!
Just to add to what you said, if the data type is long integer and if you type
in 5.99 the stored value is 6 (not 5.99) and if the format is Fixed or Standard
and the decimal places is 2, you will see 6.00.
Steve
PC Datasheet