query results as a table

G

Guest

Hi,
I ran a query got the results. I would like to save these results as my new
table. how can I do that. Could someone help me with this
 
G

Guest

Just change the query to a Make-Table query. Use the QueryType button (on the
toolbar, its icon looks like two tables overlapping). this assumes you want
to create a new table. Once you have done so, and want to ADD new information
to it later, change it to an append query, and append to the new table.
 
G

Guest

Thank You Brian, I know there is way only thing is I was looking for in run
mode instead of design mode. Now I got it. Thanks again.
 

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

query and table not connecting 1
Transpose Data that involves subquery 0
Query Returning Multiple Results 1
Make table query: [Enter 1] AS Test 1
How to display multiple IIf results in one column 1
Need Result show in Message Box 2
#error - Blank 3
Query with results in a value list from a combo box? 1

Top