Macro alternative? Running multiple queries in consecutive order?

[Justinidea]

I'm sure this is a silly question, but one never knows what is possible until one asks.

I have an Access DB with 25 queries to manipulate my data from start to finish. There are several different types of queries involved - select, make table, append and delete queries in various order.

I have a macro to run all those queries in consecutive order. Is there any way to do that with one query instead of a macro?

Thanks!!

 

[Joe4]

I think probably not, especially if you are mixing different query types. I would say even if it were, it would be a very bad idea to do that anyway. It would make debugging ("finding issues") very difficult with a query that complex. Best to break it up into multiple chunks. You may be able combine some of them to reduce the number down from 25, though.

 

[Justinidea]

Thanks for the reply.

I knew that... but I just HAD to ask