Simple: Create new access table from query result

[dewsbury]

Hi,
I am sure this is easy!
I an very familiar with relationship databases but new to access.
I want to create a new table based on the result of a query.

E.g. in the Northwind database I want to query the customer table and create a new table with only the customer name and city in it.

All help appreciated!

 

[PHV]

Take a look at maketable query.
The syntax:
SELECT fields list INTO newTable
FROM ...
WHERE ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244