how do you make multiple tables from one query?

[timf79]

I want it to group records that have the same division name and make separate tables for each. Only the divisions are going to vary from week to week so i can't build set queries to make each table.

 

[DCrake]

What is the point of making addition tables when you can replicate them in queries?

 

[timf79]

Well I need to export the results using a spec. But if you know of a way to automate this with queries, then I'm open to the suggestion. Thanks.

 

[Galaxiom]

What are you exporting to? What is the spec?

If the query is constructed to match the spec then a spec is not necessary.

TransferSpreadsheet Method will export a query to Excel.
http://msdn.microsoft.com/en-us/library/aa220766(office.11).aspx

OutPutTo can do several different formats.
http://msdn.microsoft.com/en-us/library/aa220433(office.11).aspx

 

[timf79]

I'm exporting to a text file and that the file is then being loaded into dialer software. each field has to be a specific number of characters or the diaer will not import it. But the issue is that i need for the tables (or queries) to automatically build from a constantly changing criteria.

 

[Galaxiom]

The field width can be adjusted by concatenating spaces to the end in a loop until the correct length.

The main issue though is undoubtedly the changing criteria. How are the criteria determined for each batch?