Hello,
As part of an application that I am trying to create thru MS Access, the user enters few parameters and based on that I would like the result of some predefined queries to be saved in an excel file (in separate worksheets). I have created a table which lists the name of queries in one field and user's parameters in a separate fields. When I select a command button, I like the queries run one at the time (go thru each record find the query in the table) and the results are saved in an excel file. For example, in the table below if teh user enters 1 and A, then Query-A-1 and Query-A-2 should be run and their records be saved in one excel file. I can do this by creating multple IF - statements. However, I would like to know if it is possible to do this in a differnt way (i.e one loop)
User Data 1 User Data 2 Queries
1 A Query-A-1
1 A Query-A-2
2 B Query-B-1
2 B Query-B-2
Thank you in advance.