Insert Data from one table to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have 2 identical tables. Tbl_Items & Tbl_History. I have a form that asks
the user to select a client. When the user selects the client, I want to
transfer any records with this Client name in tbl_History into tbl_Items. it
is an inspection database and so I need to carry out this operation. Any help
will be really appreciated

Regards

Neil
 
Hi,



INSERT INTO archiveTable (listOfFields) SELECT (listOfFields) FROM oldTable
WHERE oldTable.ClientID= 1004



where listOfFields is a list of coma delimited fields names. Both list must
have the same number of fields and they must "match" (compatible by data
type).

Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

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

Check text field value against underlying table of a form 1
Check text field value against underlying table or query of combo box 1
How to Populate Data from a table to another 0
After Update doesn't 2
Use a data template to reduce entry process 2
VBA - retrieve data on last create named range from previous inserted named range 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
How to export table from outlook into ms access table? 0

Back
Top