Rerunning queries automatically after export

[Drfox3]

Has any one ever set up a query that, after running and exporting the results to an Excel spreadsheet, runs anew based on a set of values in a table in the database?
Example below;
Table A has one field with values 1 -> x.
Query B runs, taking the first value from Table A
Query B finishes, exports to Spreadsheet A
Query B starts over, taking the next value from Table A.
Sequence repeats itself until the last value in Table A is used.
You are left with Spreadsheet A -> X
Table A is not the sole source of data for Query B
I hope I made this clear enough, if not let me know.

 

[alansidman]

Cross Post at this address: http://forums.aspfree.com/microsoft...ueries-automatically-after-export-424851.html

 

[Drfox3]

Thanks, I posted the same question on both sites hoping to have a response from either. Answers on the other site have not been helpful. They told me what I should do but not how to do it.