Query a Query

[Jarrod]

Using Access 2003, i want to export 50 seperate excel spreadsheets that are each a seperate query.

Basically i want to create a query of each business that contains all the relevant buildings and floors for this business

This export will have to take place many times over the coming months, with columns added and removed, however each of the 50 business unit names will remain static.

can anyone help?

[JConsulting]

Using Access 2003, i want to export 50 seperate excel spreadsheets that are each a seperate query.

Basically i want to create a query of each business that contains all the relevant buildings and floors for this business

This export will have to take place many times over the coming months, with columns added and removed, however each of the 50 business unit names will remain static.

can anyone help?

If you can answer a few questions..we'll get you going.

I assume the structure of your query will remain fairly static...and only the criteria will change to select the business stuff.
So in effect, you have 1 query, 50 different criteria?

Can you give us an example of what differentiates one business from another?

The Plan:
if you don't already have 1, create a table that will hold the criteria for each of your 50 spreadsheets.

Open that table into a recordset
plug each criteria into your query
output that to a spreadsheet
loop to get the next criteria.

Things to consider.

What do you want to name your spreadsheets when you create them? That can also be a part of the table you create...it would be a second field

How will you kick this export off? A form? a timer? a batch?

Let us know.
J