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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Date Time decimal value help please 1
Split form 0
Append Rows based on field value 2
Data changes in append query 1
How do I get Access to append the exact amount with decimals? 2
Append and Delete in one step 3
Doughnut Chart linked with the slicer in the pivot table 0

Top