How to convert a query to a table

M

Minnow

I tryed to save this query as another copy, I don'e see an option as
MakeTable query. My Access is version XP.

Can you tell me the step by step to save a query as a MakeTable query?

Thank you.
 
A

Arvin Meyer

1. Right-click on the query in the database window.
2. Choose SaveAs and give it a new name.
3. Open the new query in Design View
4. From the Menu, choose Query ... Make-Table Query ...
5. Run the new query.
6. Save the new query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top