the append query do not transfer decimal digits why?

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

Guest

dear experts:
when i run the append query it do not transfers the decimal part of a number
for example the number 1.57 transfered to the table 1.00 can you help me?
 
Check the field type of the field in the table where you append the data to,
if it's Integer or Long it will remove the decimal places. In that case
change the field type to Double or single.
 
You must log in or register to reply here.

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
Data changes in append query 1
Append Query - key violation - no duplicates, records exist in par 4
Append Query Issue 0
Access stripping decimal places in query 1
Not appending correct data 3
fractional part of value returns multiple digits 3
Decimal Field's Precision Too Small to accept the numeric you ... 3

Back
Top