| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Query Wizard - Filter Data - Dropdown missing?
Folks, I regularly use an MS Access query as a external data source for a pivot table. The Access database was recently upsized to SQL Server 2000. Now when I try and use the MS Access query as the external data source I get a funny issue. In the query wizard, when I try and filter the data using the dropdown box, the data behind the column I am trying to filter on does not appear - the dropdown is empty Other useful info: the Query joins 3 tables regards James -- jameshalligan ------------------------------------------------------------------------ jameshalligan's Profile: http://www.excelforum.com/member.php...o&userid=25597 View this thread: http://www.excelforum.com/showthread...hreadid=390140 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query Data Source Change | Excel Discussion (Misc queries) | |||
| Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
| Pull data - Advance Filter | Excel Worksheet Functions | |||
| Database Query -- Data Type Mismatch | Excel Discussion (Misc queries) | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Threaded Mode
