Append Query results in 71 instead of 71.58 (format problem?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. Make table query produces a placeholder field TMPNUM set to 0 (eg.,
TMPNUM: 0)
2. Append query appends a value in TMPNUM = 71.58
3. What shows up is 71

why is the rounding taking place and how can a fix?
 
1. Make table query produces a placeholder field TMPNUM set to 0 (eg.,
TMPNUM: 0)
2. Append query appends a value in TMPNUM = 71.58
3. What shows up is 71

why is the rounding taking place and how can a fix?
Click to expand...

Most likely you have defined the datatype of TMPNUM as Number, Long
Integer (the default number datatype).

An Integer is, by definition, a whole number. If you want decimal
places, use Number... Float, Number... Double, or Currency as the
datatype.

John W. Vinson[MVP]
 
The table you appending to, change the field TMPNUM type to double or single.
You might have a integer type, it will round the number
 
Back
Top