Amend Query round numbers when Run

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

Guest

I'm running an ammend query and when I view the data before running I have
numbers like 1.45 and 1.95. After the query is run and I look in the amended
table, the new lines show 1 and 2 respectively.

Then initial query which creates the table does so with the full decimal
values.

Any help on getting the amend query to do the same would be greatly
appreciated.
 
the fields you append to, in the second table, might be integer or long format.
Try to change them to double.
create the field on the table that you append to, to be similar to the
fields you append from.
 
Back
Top