Turn 'On' or 'Off' 'Subtotal' in Access PivotTable Forms

[RastaRam]

Hi All

This is my first time here and am hoping for some assistance.

I have an access pivot table in a form and I am able to insert/remove totals
and fields in the pivot table. However I am not able to turn 'On' or 'Off'
the 'Subtotal' on either the column or row fieldssets using code (ie VBA).

Has any one come accross this issue? Any suggestions?

Thanks so much

Ram

 

[Guest]

Hi RastaRam,

An answer (workaround) then a question:

I am having the same issue. I was told to export my query or table to an
excel file, and then run a pivot table in excel. From there you can turn off
the sub-total option from the pivot table dropdown menu.

Does anyone know how to do this in Access '03 though????

Thanks,