Possible to Pivot Chart hidden datasheet columns?

[VBAjedi]

Hey everyone,

Question: Am I correct in observing that datasheet columns that are hidden don't show up in that form's PivotChart Field list? If so, is there a workaround that will let me use a query field in a PivotChart but have that field hidden in the corresponding datasheet view?

Situation: I have a subform whose default view is datasheet. The source query returns more columns than I want to display on the datasheet, so I've hidden the undesired columns. However, I'm trying to set up a PivotChart as an alternate view of this form, and I need to use some of those hidden columns to generate the correct chart.

Thanks!

VBAjedi

 

[VBAjedi]

LOL... did my post get missed last night, or did I manage to stump everyone? Or did I just ask the question so badly that I confused everyone?



VBAjedi

 

[VBAjedi]

Call this a hopeful bump...

VBAjedi

 

[SkipVought]

Hi,

What version? Was PT created in same version?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[VBAjedi]

Hey Skip,

It hadn't occurred to me that this could be version-related. I'm using Access 2003, but as per the AC2003 default the dbase (including the PivotChart in question) is in AC2000 format.

VBAjedi

 

[SkipVought]

Don't know, but in Excel, at least, I think there was a way in 2003, to select whether or not to plot hidden data or not. Have not earthly idea in Access, though.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[VBAjedi]

Nuts.

VBAjedi