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.
 
Back
Top