Make Table Query

[aftabn10]

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.

 

[aftabn10]

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

 

[AliyuKatsina]

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