decimal value in append table

S

sierralightfoot

In append query:I have a calculated field that results in a decimal value.
The value is correct until I append to a tabel, then I get a zero. I have
set the data type for the field to:" number" and properties to: double,
percent, 1 decimal place ( and tried all other sorts of combinations) but
can't get past this.
 
J

Jerry Whittle

Percent takes the number and multiplies it by 100. This could easily cause a 0.

Also if you have a number like 1.02 formatted to one decimal place, it will
show 1.0.
 
Top