Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Pivot Table in Access
Name: confused725 Date: December 5, 2006 at 13:11:52 Pacific OS: Win XP CPU/Ram: Athlon XP2100
Comment:
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.
Summary: I am looking to combine 21 tables in access so that 1 table shows all the information. I do not want to use a query, as the tables do not get updated if new info is added. Is there a way of getting 21...
Summary: I have a Pivot Table on a Form in an Access database that is linked to a Query in the same database. It works good, no complaints. However, I want the Pivot Table in the Form to refresh automatically ...
Summary: hi all, i just got hold of a very important code demo for my vb project..it has a couple of access DBs with it..and also these are password protected.although i have the password and i can open the da...
0 
