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:-
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