the append query do not transfer decimal digits why?

W

wael

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?
 
O

Ofer

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