Pivot Table in Access

December 5, 2006 at 13:11:52
Specs: Win XP, Athlon XP2100


Is it possible to do Excel style pivot tables within Access 2000

I have a table in my database which lists records in the following fields format:-

Name
Division
Sales Volume
Month

I want to create a report or table which has month accross the top and name and division down the side, with the volume field populating the table. Obviosly this is easy to do in an excel pivot table, but can i do a similar thing in Access 2000 rather than export to excel do the pivot then import back in as a table, because i will want to run other queries on this result.

Thank you for any help



See More: Pivot Table in Access

Report •


#1
December 5, 2006 at 15:54:21

Yes, it's possible. Search for pivot table in Access Help.

Life is more painless for those who are brainless.


Report •
Related Solutions


Ask Question