Running Queries-different values

[AcceSs-AbLe]

Hello,

I want to Run a query by [Company Name]. However, I want to associate this with a macro, so that when the user clicks on Run All, it will run queries for individual companies and store it ina table and export it as CSV by individual company names. Is there a way I can write down the [Company Name] in a table or in macro as a Parameter so that it runs it automatically?

 

[klb]

How about using a form with a drop down list where the user can select the name they want.

Have the queries set up to accept the selection from the drop down list as a parameter in the query.

Add a button to run the macro that runs your queries and does the export.