Storing Information From Queries?

[soma]

I'm working with a 1gb database and have about 20 queries that analyze and
summarize the database in different ways. I tried running a separate query
that runs all 20 of these queries, but it's just too much for my computer.

Is there a way to, maybe, write a macro that runs each query individually,
and stores the result from each query? Any ideas on how to automate the
running of these queries, and store the results?

Edit/Delete Message

 

[orange via AccessMonster.com]

I'm working with a 1gb database and have about 20 queries that analyze and
summarize the database in different ways. I tried running a separate query
that runs all 20 of these queries, but it's just too much for my computer.

Is there a way to, maybe, write a macro that runs each query individually,
and stores the result from each query? Any ideas on how to automate the
running of these queries, and store the results?

Edit/Delete Message

You could have vba routine that would run each query, or you could have
buttons on a form and by clicking a button, cause a query to be executed.

What do you mean stores the result from each query?
You could have a given query be the source for a Report, and produce several
reports.

What will you do with the results? Are they being saved for some purpose?

 

[John W. Vinson]

I'm working with a 1gb database and have about 20 queries that analyze and
summarize the database in different ways. I tried running a separate query
that runs all 20 of these queries, but it's just too much for my computer.

Is there a way to, maybe, write a macro that runs each query individually,
and stores the result from each query? Any ideas on how to automate the
running of these queries, and store the results?

Edit/Delete Message

You could change them all into Append queries, appending the data into
(prebuilt) tables to store the result of the calculations. Is your database
1GByte *after compaction*? If so, I'd create the "result" tables in a new,
empty database; link to them from your original database; and append the
results into these new tables.

If you need to rerun the queries, just delete and recreate the "results"
database (keep a template around with empty tables).