I'm trying to create an append query that will append information from two different tables into two different tables. I don't know VBA so would like to do this by just using sql. I could do this with two seperate sql statements but would prefer to do it in one if possible. Any ideas? Thanks!