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

  • Thread starter Thread starter RastaRam
  • Start date Start date
R

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
 
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,
 
Back
Top