Re: how can I stop sub total rows appearing in pivot tables in excel

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 08:26:44 -0400

And to hide the subtotals programmatically, there's sample code here:

   http://www.contextures.com/xlPivot03.html#Subtotals

In Access, if you're trying to duplicate Excel's Group and Outline
feature, there's nothing similar that I'm aware of. In a table, you can
manually hide or show columns. In a form, you could probably write some
code to hide or show columns.

You can also create a pivot table in Access, and group items there.

Dave Peterson wrote:
> If you rightclick on the button like header in your pivottable, you can select
> "field settings".
>
> there's a "none" option for subtotals.
>
> If you don't get an answer for your access question, you may want to try an
> Access newsgroup.
>
> Lee wrote:
>
>>I am working in excel and I need to prevent sub total rows appearing in my
>>pivot tables. Does any know if this is possible and if so how?
>>Also, I am working in Access and I need to be able to have multiple columns
>>headers (grouped) similar to what you can do in Excel, any ideas?
>>Thanks for your help.
>>Lee
>
> 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html