ThunderGeek
Technical User
Greetings
My problem involves two tables.
Table number1 is [orders], with field name OrderID
table number 2 is [WorldShip], with field name Order_Id
I am trying to wirte an append query that appends data from orders to WorldShip. I keep getting a type mismatch when I run the append query. I know what the problem is. The data type is Long Integer, autonumber in [Orders].[OrderID] and it is text in [WorldShip].Order_Id.
My question is - can I somehow change the data type in the query with code to append?
Any help is appreciated.
Thanks TG
My problem involves two tables.
Table number1 is [orders], with field name OrderID
table number 2 is [WorldShip], with field name Order_Id
I am trying to wirte an append query that appends data from orders to WorldShip. I keep getting a type mismatch when I run the append query. I know what the problem is. The data type is Long Integer, autonumber in [Orders].[OrderID] and it is text in [WorldShip].Order_Id.
My question is - can I somehow change the data type in the query with code to append?
Any help is appreciated.
Thanks TG
