K
Ken
Good Day:-
I have a challenge with decimal places. I'm reading a price which is 8
decimals from a sql database and trying to save that entire value into a
table. However it would only save to four decimals. I have defined the field
as number with 8 decimals.... The value saved is always 4. I even used the
formatcurrency and formatnumber function but no luck. For accuracy I need the
value saved to 8 decimals.
I'm currently using Access 2003.
Any thoughts on this?
I have a challenge with decimal places. I'm reading a price which is 8
decimals from a sql database and trying to save that entire value into a
table. However it would only save to four decimals. I have defined the field
as number with 8 decimals.... The value saved is always 4. I even used the
formatcurrency and formatnumber function but no luck. For accuracy I need the
value saved to 8 decimals.
I'm currently using Access 2003.
Any thoughts on this?