Running multiple access 2007 queries

[mramnaveen]

Hi,

Please help me. I have around 15 access queries that i run every day. I want to find out a way where, all these queries could be consolidated and I just click run once and all the 15 queries run one after the other.

Really appreciate for your reply.

Thanks
Ram

[Stewart Ross]

Hi, and Welcome to Bytes!

You could set up an Access Macro to run all 15 queries in sequence as one action - it is an ideal use for the macro facilities built in to the product.

For an introduction to macros in Access 2007 click on the following link:

http://office.microsoft.com/en-us/access/HA012142021033.aspx

-Stewart