Solved

MS Access  2013

Posted on 2014-09-07
3
243 Views
Last Modified: 2014-09-22
I have MS Access 2013 but I do not have option for pivot table or pivot charts? how I can get it. thanks
0
Comment
Question by:snhandle
3 Comments
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 total points
ID: 40308775
Those options were removed from Access 2013 because there is no longer any support for OWC (Office Web Component).

The recommended alternative is to use automation, something I am not yet familiar with.

Alternatively, you can import them into Excel and use chart control to do your charts.
0
 
LVL 1

Expert Comment

by:Subramani N
ID: 40308781
They have been removed from 2013. You need to go for 2010 if you require it.

http://technet.microsoft.com/en-us/library/cc178954(v=office.15).aspx

Or to pivot using queries, use UNION ALL.
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40309996
Please complain to Microsoft.  It doesn't mean they will put deprecated features back but maybe it will stop them from deprecating more features in the next release.  The other big loss for A2013 was the ability to link to FoxPro and dBase tables.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question