Hello,
I have a table that lists all locations for a customer. I have to create a seperate report for each location. How do I set a query to use the values in the location table as the filters for each run. I want to use vba to run through the query multiple times using each location value in the table as a filter.
Hope this makes sense......
I have a table that lists all locations for a customer. I have to create a seperate report for each location. How do I set a query to use the values in the location table as the filters for each run. I want to use vba to run through the query multiple times using each location value in the table as a filter.
Hope this makes sense......