Query to run multiple queries

  • Thread starter Thread starter JT-TCP
  • Start date Start date
J

JT-TCP

Hello. I have two queries (a Make Table query and an Append Query) that I
would like to run simultaneously by just running one query. Is there some
kind of action query to do so? It seems I might have to use SQL but I have
never done so. Please advise.

Thank you,

James
 
Hello. I have two queries (a Make Table query and an Append Query) that I
would like to run simultaneously by just running one query. Is there some
kind of action query to do so? It seems I might have to use SQL but I have
never done so. Please advise.

Thank you,

James
Click to expand...

You can use a Macro to run two queries in a row. Or VBA code.

May I suggest that you don't use MakeTable? MakeTable creates a brand
new table object each time it runs, and Access can take liberties with
your table design.

A better practice is to have a permanent table, then run a queries to
delete all the records in it (Delete * from MyTable) and reload it
(Append).

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Thank you for your response. I appologize about the multi-post in the query
section. I did not know which category to post my question under.

-James
 
Back
Top