Create an Access Table from an Access Query

W

wnfisba

We are dealing with Microsoft Access 2003. Is there any easy way to turn a
query into a table???

Thanks in advance for your help.

wnfisba
 
W

Wayne-I-M

Hi

Open the query in design view and select the View option. Select Make Table
choose a name and save. Right click the query and select open. You will be
asked if you want to make a table. Click Yes.
 
E

Ed Metcalfe

Change it to a Make Table query:

Open the query in design view, go to Query>Make-Table query..., enter the
name of the table you want to create, press OK. Now run your query.

Ed Metcalfe.
 
Top