query results as a table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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

Make table query: [Enter 1] AS Test 1
Transpose Data that involves subquery 0
query and table not connecting 1
Remove a result from a query 2
How to display multiple IIf results in one column 1
Update Field from Query Result 1
Need to show result in message box 1
Need Result show in Message Box 2

Back
Top