467,116 Members | 1,221 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Pivot Tables Access vs Excel

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
Dec 24 '05 #1
  • viewed: 3567
Share:
1 Reply
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

Dec 24 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Prasad Patil | last post: by
4 posts views Thread by Del | last post: by
3 posts views Thread by Jerry K via DotNetMonster.com | last post: by
3 posts views Thread by nikila | last post: by
9 posts views Thread by PeteCresswell | last post: by
9 posts views Thread by patrick.waldo@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.