mycotropic
Technical User
HELP!
OK; I type in 5.1 into a field where;
field size = Single
format = standard
decimal places = 1
and, when i export that value to excell it tells me that the value is;
5.09999990463256
I didn't type that number in Bill - where did it come from?
this also hapens in a file defined as;
field size = Single
format =
decimal places = 1
In many cases the difference between what I type and what Access stores is;
0.40000009536743
which makes me think that a standard process is occuring without my requesting it.
Please help - these are lab values and MUST be stored as I type them in.
Thank you for any help you can give;
Greg Kinney "Man is the cheapest computer we can put into a spacecraft and the only one we can mass-produce with unskilled labor." Werner von Braun
OK; I type in 5.1 into a field where;
field size = Single
format = standard
decimal places = 1
and, when i export that value to excell it tells me that the value is;
5.09999990463256
I didn't type that number in Bill - where did it come from?
this also hapens in a file defined as;
field size = Single
format =
decimal places = 1
In many cases the difference between what I type and what Access stores is;
0.40000009536743
which makes me think that a standard process is occuring without my requesting it.
Please help - these are lab values and MUST be stored as I type them in.
Thank you for any help you can give;
Greg Kinney "Man is the cheapest computer we can put into a spacecraft and the only one we can mass-produce with unskilled labor." Werner von Braun