G Guest Jun 18, 2007 #1 I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I want to copy all values in Fld3 to Fld1. How can I do it
I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I want to copy all values in Fld3 to Fld1. How can I do it
C Carl Rapson Jun 18, 2007 #2 AccessLover said: I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I want to copy all values in Fld3 to Fld1. How can I do it Click to expand... INSERT INTO Tbl1 (Fld1) SELECT Fld3 FROM Tbl2; Carl Rapson
AccessLover said: I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I want to copy all values in Fld3 to Fld1. How can I do it Click to expand... INSERT INTO Tbl1 (Fld1) SELECT Fld3 FROM Tbl2; Carl Rapson
G Guest Jun 19, 2007 #3 How can I do it in design view in access Carl Rapson said: INSERT INTO Tbl1 (Fld1) SELECT Fld3 FROM Tbl2; Carl Rapson Click to expand...
How can I do it in design view in access Carl Rapson said: INSERT INTO Tbl1 (Fld1) SELECT Fld3 FROM Tbl2; Carl Rapson Click to expand...
C Carl Rapson Jun 19, 2007 #4 Create a new query based on Tbl2. Select Append Query and specify Tbl1 as the table to append to. Under Field, select Fld3 (Table should be Tbl2). Under Append To, select Fld1. Then run your query. Carl Rapson
Create a new query based on Tbl2. Select Append Query and specify Tbl1 as the table to append to. Under Field, select Fld3 (Table should be Tbl2). Under Append To, select Fld1. Then run your query. Carl Rapson
