decimal value in append table

G

Guest

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.
 
G

Guest

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

How do I get Access to append the exact amount with decimals? 2
Append Rows based on field value 2
Access Macro Repeat Expression using value of a field in table 0
Data changes in append query 1
Append and Delete in one step 3
change data type from decimal to double 2
Access stripping decimal places in query 1
Decimal places in calculated fields 6

Top