turning query into table 1

[blaine011]

I have an access table that has not been normalized. I need to take fields such as country and city and turn them into separate tables. How to I turn a query into a table?

 

[LittleSmudge]

Develop your query in the MSAccess query pane as usual.

View it to check that it does what you want

Then from the Query menu select MAKE TABLE QUERY

Then supply the name of the target table

Then click on the Exclamation Mark tool to run the query and make the table.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[BNPMike]

You can turn it into a Make-table query or better still declare your table manually and load it with your query turned into an Append query.

Select these options by finding the icon on the tool bar that says 'Query Type'