I use MS Query to pull data from a central DB into Excel for reporting. The data that I pull contains records for many locations that my company operates. I am trying to build some reporting that would ideally work like this:
-After I query the master DB for ALL records, I park those in a tab in the Excel workbook for referencing
-However, when I report, I need to be able to "hide" data for locations I am not currently reporting on
-I envision a drop down list where I select the specific location and the report looks to the "data tab" for all records from that location and then populates the record ID numbers for that location only. Essentially, it would be a lookup of a value (location #) in the "data tab" and would return ALL the records associated with that location.
Any ideas?
-After I query the master DB for ALL records, I park those in a tab in the Excel workbook for referencing
-However, when I report, I need to be able to "hide" data for locations I am not currently reporting on
-I envision a drop down list where I select the specific location and the report looks to the "data tab" for all records from that location and then populates the record ID numbers for that location only. Essentially, it would be a lookup of a value (location #) in the "data tab" and would return ALL the records associated with that location.
Any ideas?
