How to Enable Scrolling in a MS Access Pivot Table

I have a MS Access pivot table form which displays all of the results as intended, however, the far right fields extend past the default display window size (even when maximized). I cannot figure out how to scroll horizontally to view these extreme fields. Does anyone have any advice on how to scroll horizontally to view all results in a MS Access pivot table?
jknuceAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
OK,

I downloaded the file Again.

First I will ask why you have so many fields in the PT?
You appear to have included every field in the table in the Row headings.
(Why would you need to pivot on, or summarize by, all 4 "Comment" fields?)

AFAICT, you did not (or could not) drop any fields in the "Data Area", or the Column Headings, ...thus, no horizontal scroll bars.

A PT is used to summarize data.
Under normal circumstances you will have perhaps no more than 7 fields
(Three levels in the Rows, 3 levels in the columns and one in the Data area.
...not "All" the fields in the table.
Any more than this and IMHO, the PT becomes unreadable.

An example using the data your table data would be: Annual Income By Name and State
Or:
Annual Income By Sex and Zipcode
Again, here you have one field in the rows, one field in the Columns and one numeric field to summarize.

Including all tables fields in the PT serves no real purpose that I can see.

So to address your issue of not having any scrollbars directly:
You have no Column Fields of Data Fields.

So the next question must be:
What, specifically, were  you  trying to display in this Pivot Table?

;-)

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Buy a mouse with a "Horizontal Tilt" scroll wheel.
It works great for Excel, Access and all the new "Wide screen" apps and websites.

http://www.microsoft.com/hardware/mouseandkeyboard/features/tiltwheel.mspx

;-)

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
<I cannot figure out how to scroll horizontally to view these extreme fields.>
Are you saying that you do not have a horizontal scroll bar?
untitled.JPG
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
jknuceAuthor Commented:
I see the scroll bar in your entry, but on multiple computers and using various tables of data, the bar is not observed when creating a Pivot Table form of a query in MS Access. Is there a trick to enable the horizontal bar? Is there a series of steps I can attempt to determine if it is user error? I have attached a screen shot of one of the samples that exhibits this problem.
Access.JPG
0
 
Jeffrey CoachmanMIS LiasonCommented:
This appears to be a resolution issue.

The scroll bars will appear for "Data Areas" that exceed the screen.

In your screenshot, you have so many grouping levels (?!) that the Data Area is not visible.

If you first Scroll "Down" (to see the data Area), do the Horizontal scrollbars appear?

;-)

JeffCoachman
0
 
jknuceAuthor Commented:
No the bar is not present and this holds true for new databses on different machines, with different installs. Attached is a ficticious databse I threw together to demonstrate the problem. Also attahced are screen shots of the table scrolled down.
Screen-Shot-1.JPG
Screen-Shot-2.JPG
No-Horizontal-Bar.zip
0
 
Jeffrey CoachmanMIS LiasonCommented:
I cant see what your sample is supposed to be showing me?
Linked Excel files??

Can you just post a simple query based on a static table that displays this issue?
0
 
jknuceAuthor Commented:
I attached the zipped Access databse. There are no linked excel files. Can you not download the zipped database? The only form int he databse is the pivot table form. The screenshots also clearly show the horizontal bar is missing. The query returns a datasheet view. it is the pivot table view of the form that exhibits this problem.
0
 
jknuceAuthor Commented:
The databse provided was merely an extreme example I put together that exhibited the problem I was encountering with my true data (row fields exceeding the display window), which I could find no way to scroll to the right. I belive that this is what you and I have confirmed, which does not solve my problem. I was able to confirm that if the data is dropped in the Totals or Detail Fields (Data Area), I am able to scroll that section.  However, in this particular manner, I  use the pivot table view to display the results of a databse filtered in a particular manner (horizontally as a collapsed tree), which can be expanded if additional details are desired by the user. Using the "Data Area" for this design does not yield the desired view. Additionally, my data does not contain any values needing totaling. I believe the inability to scroll the row fields sections when they exceed the display to be a design bug of Access, but I have found a work around by limiting the fields in this particular PT. Thanks for help clarifying the problem.  I'll award full points for your assitance.
0
 
jknuceAuthor Commented:
This appears to be a design bug that would allow additional field rows in the table, but no manner of scrolling and viewing them.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK,

But to be honest, I don't think that Pivot tables were not designed to display data in the way you were requesting.
But you are correct in that if they allow you to insert a certain number of fields, then you should be allowed to scroll through those same fields...

Again, they were meant to summarize data.
So you could plot Employees in the rows and Countries in the Columns then get a sum of sales in the Data area.
Sum sales by Employee and Country

As an alternative you might want to investigate "Crosstab" queries, or even Grouped reports.

But I am glad you got  found some value in my post.

;-)

Enjoy your weekend.

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.