How to convert a query to a table

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Convert MBOX to PST Online? 3
How to Convert EML to PST? 2
How to Convert EML to PST in 2025? 2
How can we convert OST to PDF file format? 1
Convert a memeo field to a text field 6
converting a date 2
Which is the best MBOX Converter Tool different formats conversion? 4
Convert WAV to MP3 4

Back
Top