Query Wizard - Filter Data - Dropdown missing?

J

jameshalligan

Folks,

I regularly use an MS Access query as a external data source for
pivot table. The Access database was recently upsized to SQL Serve
2000. Now when I try and use the MS Access query as the external dat
source I get a funny issue. In the query wizard, when I try and filte
the data using the dropdown box, the data behind the column I am tryin
to filter on does not appear - the dropdown is empty

Other useful info: the Query joins 3 tables

regards

Jame
 
Top