how do i save a query as a table?

[leo]

i made a query and now i just want to make that query a table

 

[Dennis]

Right Click in the top half of the query design and then select query type.
One of the options is to make table. Select this, give it a table name and
then run the query.

 

[John Vinson]

i made a query and now i just want to make that query a table

You can change it to a MakeTable query but... it is VERY rarely either
necessary or appropriate to do so.

If you have a Query you can...
Create a Form based on the query
Create a Report based on the query
Export the query to Excel, or a text file, or many other formats
Search the qeury
Sort the query
Base another query on the query

You can do all of these things with a Table, too, but storing the data
that already exists in your Query into a table means you're storing
the data redundantly. You now have the same data stored in two
different places, and updating will become a real problem!


John W. Vinson[MVP]

 

[leo]

Thank you

You can change it to a MakeTable query but... it is VERY rarely either
necessary or appropriate to do so.

If you have a Query you can...
Create a Form based on the query
Create a Report based on the query
Export the query to Excel, or a text file, or many other formats
Search the qeury
Sort the query
Base another query on the query

You can do all of these things with a Table, too, but storing the data
that already exists in your Query into a table means you're storing
the data redundantly. You now have the same data stored in two
different places, and updating will become a real problem!


John W. Vinson[MVP]

 

[leo]

THANKS

Right Click in the top half of the query design and then select query type.
One of the options is to make table. Select this, give it a table name and
then run the query.