Pivot Table Report

[newguy86]

What I'm trying to do is create a single report that allows the user to view overall turnaround times for all work orders in our system but also gives them the ability to drill down to specific regions and teams to see how they stack up against each other.

I'm figuring that the easiest way to do this would be to use a pivot table but I'm having difficulty finding that option (I'm using Access 2013). I know that it was available in previous versions of access but I can't seem to find it in 2013.

So my question is, how do I setup a pivot table in Access 2013? Or is there an easier way to go about doing this?

Any assistance will be appreciated,

Travis
Charter Media

 

[dhookom]

Pivot tables have been removed. You might be able to use a crosstab query but we don't know much about your specific requirements.

Duane
Hook'D on Access
MS Access MVP

 

[newguy86]

Well what we have is a hierarchy built to not only identify which sales offices belong to which regions (Central, Pacific, etc), but which sales offices belong to which corporate office that manages them (STL, TN).

What I wanted to do was have a report that showed the average turnaround time on work orders for each corporate office but also have the ability to drill down to specific orders in the data. I have a query setup to show the turnaround time for each work order along with the hierarchy attached to it so that things can be grouped as needed but I just need a way to see the data grouped on the fly from either a high level (corporate office) all the way down to specific orders.

I'm not sure a crosstab query will work because I'm only using 1 dataset.

Travis
Charter Media

 

[dhookom]

Maybe this article will provide some help. I have never used the report view.

Duane
Hook'D on Access
MS Access MVP