Append query rounding

  • Thread starter Thread starter Max
  • Start date Start date
M

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?
 
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?
Click to expand...

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.
 
Back
Top