please help me..numbers in field

[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

 

[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.

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

 

[PC Datasheet]

Double check again!

It's impossible to get 6.00 when the data type is set to Number|Long Integer!

 

[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

 

[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