Hello,
Has anyone experienced problems with a field that randomly rounds and pads numbers on only certain rows? Stranger still is that the rounding doesn't even seem to make sense. For instance, I entered "48.9" and instead of getting "48.900000", I got "48.900002". Also, some records don't get padded or rounded at all. when I entered 42.75, I got 42.75. Then in the row immediately following, I entered 43.05 and I got 43.0499999. I have set my field to Float with 6 decimal places which has worked for me before when entering this kind of data.
Is this a bug, or have I just overlooked something? Any help would be appreciated.
-Greg