17 Replies Latest reply on Sep 22, 2011 1:44 AM by WolgangW

    Insert from one table into another - I searched .. :(


      I have a query of a table of data..  I have another identical table (same fields) that I need to transfer the all the data associated with a client ID and insert it into another table.  Than, remove the data from the 1st table.


      Story:  a client enters transacations into a database table called "open".   At the end of the day, he/she will run the query - print a report and click a "close" button that I need to take this data in "open" and insert it into "closed". table.


      Thanks for your help.