Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 9th, 2010, 11:27 AM
iwyll iwyll is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2009
Posts: 100 iwyll User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 2 m 33 sec
Reputation Power: 6
Can i create an Access report from a Pivot Table view?

I have some tables from which i have created Pivot Tables to view the data better. can i create an Access report from a Pivot Table view? I've encountered some problems while trying to do this because it will create the report out of the table itself not out of its Pivot Table view.

Is this somehow possible?

Reply With Quote
  #2  
Old March 9th, 2010, 11:48 AM
AlanSidman's Avatar
AlanSidman AlanSidman is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2008
Location: Lake County, IL
Posts: 240 AlanSidman User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 15 h 49 m 19 sec
Reputation Power: 7
I'm not sure what you are asking. Are you asking to print a pivot table as a report in Access? If so, why not export the pivot table to Excel and print it there? Or run the query and export it to Excel -- run your pivot and print or distribute it? Data manipulation is often easier in Excel than in Access.

Alan
__________________
Alan Sidman
__________
If I helped you, I'd like to know. Click on the icon next to the thread number and tell me.

Reply With Quote
  #3  
Old March 9th, 2010, 12:09 PM
iwyll iwyll is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2009
Posts: 100 iwyll User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 2 m 33 sec
Reputation Power: 6
re:

I know but I have a client that wants the Pivot Table to be in Access. So I have a table that I open and then when i go to this table's Pivot Table view i have a Pivot Table set up there.

I also found another way of making a Pivot Table in Access by going to Forms/More Forms/Pivot Table and I was able to do there but I don't seem to be able to create an Access report out of this form either. When i try exporting this form to excel, I will not export the calculated fields I have on the Pivot Table.

Any ideas?

Reply With Quote
  #4  
Old March 9th, 2010, 05:29 PM
AlanSidman's Avatar
AlanSidman AlanSidman is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2008
Location: Lake County, IL
Posts: 240 AlanSidman User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 15 h 49 m 19 sec
Reputation Power: 7
Found this when I did a google search. Most of the searches came back telling how to create a pivot table, which is not what you are looking for. If this is not your answer, then I would start doing some google searches. I am sure it is out there, but not often used and will probably require some VBA.

http://bytes.com/topic/access/answers/504462-pivot-table-report

Good luck

Alan

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Can i create an Access report from a Pivot Table view?


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap