Access 2002 - Pivot Tables

[JFF]

I'm an intermediate user of the Access in Office XP, but cannot figure out how to attach advanced filters to any Pivot Table design in Access.
It appears you can attach very simple filters by dropping them into the "Filter Fields" section of a Pivot Table design, but how do you include more adanced filters like the Filter by Form and Advanced Filter that we have available in our regular Access, Form view?

Thanks in advance
John

 

[JFF]

Well it really surprised me in my first question ever on this forum, that no one knew any answer to my posted question about filters in Pivot Tables.

After further work I guess the best answer without using code, is to design the Pivot Table and then go into Form View in it. Then the Filter by Form and Advanced Filter features of Access become available. Complex filters can be applied there. Then you just return to Pivot Table view and the filter will remain in effect.

Note - if you do Auto Filter in Pivot Table view it will remove any Form or Advanced filter.

Figured I would post my own answer so I could be helpful to anyone in the future who looked for help on Pivot Table filters.

John