Ok. Actually what I am trying to do is append a field. So what I did is I created a Join for the 2 tables. I want to append the data from one table to another. It is basically only filling that field. Here is my code:
INSERT INTO dbo_Trocar_Master ( Standard_Cost_at_First_Shipment )
SELECT dbo_Item_Master_Table.Accum_Material_Cost
FROM dbo_Trocar_Master INNER JOIN dbo_Item_Master_Table ON dbo_Trocar_Master.Trocar_Part_Number = dbo_Item_Master_Table.Item_Number;
And here is the error that I am getting:
Microsoft Access can't append all the records in the appent query.
Microsoft Access ser 0 field(s) to Null due to a type conversion failure, and it didn'e add 10 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.