I wrote a simple macro to transfer the data in one table to another table in a separate database. I cannot figure out how to then delete the data from the first table. I do not want the data in two places. I suspect I may have to create a module and write some code, but I have not done this before.