pivot table programming

  • Thread starter Thread starter Elsie
  • Start date Start date
E

Elsie

Hi, I have a pivot table in Access, but there was some issue when printing.
So I am thinking of using the 'Export to MS Excel' button and then use some
VBA programming to do some grouping and sub-total.

Suppose that rows containing accounts starting with 600 are in group1, I
need to group all these accounts and to have a sub-total for this group. How
do I program these?

Please help.

ps: The pivot table in Access does not allow me to adjust the output format
much, hence I am thinking of using Excel.
 
It might be easiest to record a macro when you do it manually. Then you'll have
some code that works (but may need tweaking).
 
Back
Top