Copying Information

[dkbrostyle]

Hi my problem at the moment is that, within my database i have created a search query, so a search is made then the details are displayed. What i want to do now is create a macro or fuction in which after a search is made and the details are presented in a form view is to have a button which is clicked and what has been searched for is then copied to another table.

My problem here is that i know that an append query has to be used but i don't know how to design it, so it would be like after a search is made, a command button would be press which would run the append query.

Thank-you for your help and time.

 

[anvil19]

Hi dkbrostyle

An append query is written like so :

INSERT INTO <TargetTableNameHere>
SELECT <FieldNamesHere> FROM <DataTableNameHere> WHERE...

You can use any valid SELECT statement, including joins, Group By or even references to other queries etc.

In your case you could run a query against Table A and Table B and that returns records not in the table A, and then Insert the new data into table A, like so:

INSERT INTO TableA
SELECT Value1, Value2, value3, value4 FROM TableA
RIGHT OUTER JOIN TableB ON TableA.value1 = TableB.value1;

assuming value1 is a value in TableB that is not in TableA, yet. In a Right Outer Join, all unmatched records from the table on the right (of the ON statement) are preserved.

Try that

anvil19