M2

 

Those are the screenshots of how I created a query. I went to create, query design, selected the table that I wanted to append the query to, clicked add then close. After I have chosen all the fields that I want to show up in the table, I had to append my query by clicking append to. I had to click the table that I wanted all the information to go to, then click run. I then had to click yes on a few more tables that popped up to confirm that I wanted to append to the table and then I had to save my query.