I would like to create Pivot table report on access 2016
This is a duplicate of another suggestion.
The fact that you need unnecessary extra steps to create a PivotTable by exporting it to excel plus the need for other extra cell adjustments is a very waste of time and annoying especially when using such tools frequently. Access should have its own PivotTable tool just like the previous versions and not crossing from one program to another. I do not expect to use other program like Excel or PowerBI to get what many of us want when this was seamlessly done through Access by itself. Its an indispensable tool that Access should get back. PivotTables make Access more usable and powerful. WE NEED IT!
Valdemar Nebonyr commented
Yes, ms access pivot was powerful. I need it. Crosstab query cannot operate with text raws as pivot did.
V K Mourya commented
Pivot table is a big requirement for us in access. I request to add it or provide an alternate way. Using Excel is not that powerful as was access pivoting.
Yes please, bring back pivot tables in Access or at least allow us to embed an excel spreadsheet for charting. Access is for data analysis and removing a primary way to group and sort data wasn't helpful.
What is your actual suggestion ?