how do i save a query as a table?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
i made a query and now i just want to make that query a table
Click to expand...

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]
 
Thank you

John Vinson said:
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]
Click to expand...
 
THANKS

Dennis said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using select query results as filter for append query 14
How to save a Query as a Table? 3
I do I find the query that made a table? 16
Make table using Union Query 2
A SQL problem 7
Making a query that creates a value base on a table value 8
Invalid Argument when running a Make Table Query 3
Parsing a table 1

Back
Top