P
Pat
I ran an update query to find certain values in a table and replace them with:
-9999.999999 for my single format columns (6 decimal places)
-9999.99999999999999 for my double format columns (14 decimal places)
Access presented a message saying it had done so but when I look at the
table, the updated values are -10,000.
If I repeat the update query to replace -10,000 with the above values,
Access presents a message saying it will replace the same number of rows as
before with the above values, meaning that it really is -10,000 that it
updated to the first time.
Why won't it give me the decimal precision it should?
Thanks,
Patrick
-9999.999999 for my single format columns (6 decimal places)
-9999.99999999999999 for my double format columns (14 decimal places)
Access presented a message saying it had done so but when I look at the
table, the updated values are -10,000.
If I repeat the update query to replace -10,000 with the above values,
Access presents a message saying it will replace the same number of rows as
before with the above values, meaning that it really is -10,000 that it
updated to the first time.
Why won't it give me the decimal precision it should?
Thanks,
Patrick