Put data from one table column into another table

[lagingtoo]

How do I make a query to insert data from one column to another




I tried this but it didn't work

INSERT INTO SE_REPORT
SELECT [SE Lead / NGM].*
FROM Buyers INNER JOIN SE_REPORT ON SE_REPORT.[Buying Organization ANID]=Buyers.[Buying Organization ANID];

I am trying to put data in the column SE Lead / NGM from the Buyers table into the SE_Report table with column SE Lead / NGM. Also I want the Supplier Manager Liason column in there too but I am sure it is the same code as the other one.


Here is the database file:

datahelp.zip

[recyan]

Did you try making a Make Table Query
with
tables SE_REPORT and Buyers
using
LEFT JOIN
ON
SE_REPORT.[Buying Organization] = Buyers.[Buying Organization]
&
then selecting the columns that you want from both the tables.

Thanks