Question query

[gctsundar]

hi i have two tables with me. with 5 columns each. i am running a join query for getting a result. i want that resultant data to get inserted into a new table. through a form.on clicking of a button the query should get executed and the output of the query should get inserted into a new table. how can i achieve this?

 

[John Big Booty]

Via an append query, if you just want to insert the data into a different table, or use a Make Table query if you want to create a completely new table.