can you change a query to a table?

S

Stephen

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
 
T

tina

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
 
Top