Client is using Excel 2003. She has a pivot table that is linked to an Access
query. When looking at the SQL statement using the addin Pivot Play, we can
see the DeptDesc field. When looking at the field list visible in Excel
ptable, DeptDesc is not listed. However, if we use the option to "Show
detail" from the ptable, there is a column with data for the DeptDesc field.
It appears to be hidden somehow in the ptable field list. Where might this
field be hidden?
--
maryj