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