Append query rounding

[Max]

I have an append query that rounds off all digits despite
that fact that in both the query and the table field
settings specify rounding to 2 digits. The formula in the
query also has ROUND( expr, 2) specified to ensure that
all digits are intact, but the output is still just two
zeros after a decimal point.

Any suggestions?

 

[John Vinson]

I have an append query that rounds off all digits despite
that fact that in both the query and the table field
settings specify rounding to 2 digits. The formula in the
query also has ROUND( expr, 2) specified to ensure that
all digits are intact, but the output is still just two
zeros after a decimal point.

Any suggestions?

I'd suggest you check the datatype of the field into which you are
appending the data. The default Number datatype is Long Integer, which
*is* an integer: no decimals.

Use either a Number... Float (for 7 digits precision), Number...
Double (for 17 digits precision), or perhaps best, a Currency
datatype. The latter is a scaled integer with exactly four decimals
and does not have the problems of roundoff error of the Float and
Double datatypes.