accessfever
Registered User.
- Local time
- Today, 01:44
- Joined
- Feb 7, 2010
- Messages
- 101
Hi, I have a 500K+ Access table which has detail information of 4 product type, tons of product names and 10 manufacturing locations. Currently, I have 40 queries to download the table by product type by locations in Excel and run a macro to execute the file downloading. I wonder if there is a way to minimize the 40 queries into just 4 queries (one query one product type) then use a macro or VBA code to breakout further by locations. I'm asking this since it is time consuming to update those 10 to 40 queries (one product type = 10 download files) when there is a request to change the download files' layout.