Just a quick question, I have created a make table query and when this is ran it will overwrite my table "Table1". I now want to copy this query but want it to create a table called "Table2" now but how would i change this in the query?

Could somebody please help. I know i would be able to create the query from scratch, but just wanted to find out to build my knowledge in access.

Thanks in advance.

lol... iv actually found the solution within the SQL.

Copy your query with another name. Open it in SQL view, you will see the INTO statement. Change Table1 to Table2. Save and run the query.
I hope this works