please help me..numbers in field

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

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.


"jokay" wrote in message
...
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

Double check again!

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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"GVaught" wrote in message
...
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.


"jokay" wrote in message
...
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 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" wrote in message
ink.net...
Double check again!

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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"GVaught" wrote in message
...
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.


"jokay" wrote in message
...
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

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



"tina" wrote in message
...
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" wrote in message
ink.net...
Double check again!

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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"GVaught" wrote in message
...
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.


"jokay" wrote in message
...
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