Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to create a Pivot Table?
- Thread starter Buj123
- Start date
gusbrunston
Programmer
[tt]
What specific questions do you have about building a pivot table?
I typed the following into the Answer Wizard in "Help" and found 11 pages of information:
"How do I create a pivot table?"
[/tt]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]
What specific questions do you have about building a pivot table?
I typed the following into the Answer Wizard in "Help" and found 11 pages of information:
"How do I create a pivot table?"
[/tt]
[tt]Gus Brunston - Access2000(DAO)Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]
Buj123,
Not that you asked for my opinion - but I just thought I'd mention to you that I have found it is much easier to create, manipulate, maintain pivot tables in Excel than it is in Access (97 at least).
what I do is I create my pivot tables in excel, then in the database simply put a hyperlink to the excel file.
When I am creating the pivot table - I use external data as the source, and select the table or query from my access database that I want as the data source.
I have found it much easier to maintain the pivot table in excel.
Best of luck to you!
Lisa.
Not that you asked for my opinion - but I just thought I'd mention to you that I have found it is much easier to create, manipulate, maintain pivot tables in Excel than it is in Access (97 at least).
what I do is I create my pivot tables in excel, then in the database simply put a hyperlink to the excel file.
When I am creating the pivot table - I use external data as the source, and select the table or query from my access database that I want as the data source.
I have found it much easier to maintain the pivot table in excel.
Best of luck to you!
Lisa.
gusbrunston
Programmer
[tt]
Cool.[/tt]
[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]
Cool.[/tt]
[tt]Gus Brunston - Access2000(DAO)Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]
- Status
Similar threads
- Locked
- Question