Pivot Tables Access vs Excel

[Jerome Ranch]

I consider myself an Excel PT wizard of sorts, but now I have a
situation with so much infromationthat I need to categorize and
summarize, that I will use access to manage it.
Interestingly, though, the pivot tables in excel 2003 do not resemble
the pivot tables in access 2003 as closely as they did previous
versions of the products.
One of the most powerful features for me is the grouping function.
In excel 2003 if one right clicks date information or nemeric
information inthe ros, one could group data by month, year, quarter
week, or virtually any combination. Also with numeric row data, one
could group dat counts from 0 to 100 in increments of 10, for
example.. I don't see where these capabilities are in Acces 2003.
When I build a pivot table in access 2003, and I group, I get another
copy of the row field, and some + and- boxes to expand or contract the
selection, but no way to really group the data.
I'm confused. I get no help from access help, and virtually all the
pivot table help on google is for excel.
I bought a couple of access 2003 books, but no help there either.

Thanks
Jerry

[Jerome Ranch]

I answered my own ??
After posting I went back again to work on this.
I accidently discovered that when one right clicks a data poit in the
row item, and then chooses properties from the drop down list, the
grouping functionality is available
I am so glad to have found it
Jerry

On Sat, 24 Dec 2005 06:06:48 -0600, Jerome Ranch <ra*****@mchsi.com>
wrote:

I consider myself an Excel PT wizard of sorts, but now I have a
situation with so much infromationthat I need to categorize and
summarize, that I will use access to manage it.
Interestingly, though, the pivot tables in excel 2003 do not resemble
the pivot tables in access 2003 as closely as they did previous
versions of the products.
One of the most powerful features for me is the grouping function.
In excel 2003 if one right clicks date information or nemeric
information inthe ros, one could group data by month, year, quarter
week, or virtually any combination. Also with numeric row data, one
could group dat counts from 0 to 100 in increments of 10, for
example.. I don't see where these capabilities are in Acces 2003.
When I build a pivot table in access 2003, and I group, I get another
copy of the row field, and some + and- boxes to expand or contract the
selection, but no way to really group the data.
I'm confused. I get no help from access help, and virtually all the
pivot table help on google is for excel.
I bought a couple of access 2003 books, but no help there either.

Thanks
Jerry