Create table from a Query

[rollox]

Hi

I am new to access and am wondering if you can create a table from a Query. I have a replicated database which I am trying to "unreplicate". I am following the steps outlined in the Help Menu. I am looking for a shorcut rather than manually create each table and copy the data into the new table from the Query.

I hope this makes sense and that someone can help

Thaking you in advance

Rollox

 

[mcfaddea]

Hi
Select new query
select design mode
From menu-bar selct query and then select make table query, you can also use queries to update or append records to a table.

Alan

 

[rollox]

mcfaddea

Thanks for the prompt response. Followed the instructions and successfully created the table.

Cheers

Rollox