turn a query automatically into a table

J

jennifer

I am wondering if there is a way to automatically turn a query into a table
once the query has ran. Thanks for your help.
 
J

JulieS

jennifer said:
I am wondering if there is a way to automatically turn a query into
a table
once the query has ran. Thanks for your help.
Click to expand...

Jennifer,

Try changing the query type from a select query to a Make Table
query. You can also save the results of a query as a table through
File > Save As.

I hope this helps.

Julie
 
J

John W. Vinson

I am wondering if there is a way to automatically turn a query into a table
once the query has ran. Thanks for your help.
Click to expand...

As Julie says, you can change the table into a Maketable query. However, this
should VERY rarely be necessary! There is very little that you can do with a
Table that you cannot also do with a query; you can base a Report or a Form on
a query, you can export the data to an external file, you can (usually) edit
the data, etc. Why do you feel that you need to do this? What use will be made
of the table?
 
Top