Runnig a series of make-table queries

[timbar]

I have many make-table queries that I run one after the other. These queries simply extract a subset of records from a larger source table.

I'd like to automate the process, so that I don't have to run each query one at a time, using a macro (I assume) to initiate and run all the queries that I specify.

Is this possible? Is a Macro the right approach? Can anyone offer an approach or guide me in setting up to automatically run multiple queries that I specify?

Thanks in advance for you help.

Tim Barbour
timbar@att.net

 

[raskew]

Tim -

What is it about your data or requirements that makes normal Select queries inappropriate? Would you post the code from a couple of your queries to give us an idea of how they differ from one-another.

Bob