Copy from one table to the other

A

AccessLover

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

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab guery from multitables 2
Concat Values Not Appearing in Query 3
plus sign applied as & 4
Update Query 4
query to return only unique records from 2 tables? 2
Append table with If then else 2
Dynamic Pivot Table 0
Query Help 4

Top