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

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.


--
Wayne
Manchester, England.



"wnfisba" wrote:

> 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

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.

"wnfisba" <(E-Mail Removed)> wrote in message
news:F2F5BA99-F9B1-4CF4-9DEE-(E-Mail Removed)...
> 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