can you change a query to a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello I have a Query that I need to change to SQL the only way i can do this
is if the query becomes a table.

is there any way to convert a query to a table?

if so please let me know

thanks in advance
 
open the query in design view. from the menu bar, select Query | Make-Table
Query. in the dialog box, type a name for your new table and click OK. back
in design view, from the menu bar again, select Query | Run (or click the
exclamation point ! button on the toolbar). after the table is created,
close the query. you can either save the changes in the query, or not, as it
suits you.

hth
 
Back
Top