Results 1 to 2 of 2
  1. #1
    David Hare-Scott

    Pivot table view (Access 2002)

    I have been playing with pivot table view in Access 2002 and something is very wrong as I get nothing useful. I have run the pivot table form wizard and specified a table as source, then a form opens blank with a wizard box showing the fields. No matter how I drag fields on to the form all I get is columns like in datasheet view. If I try to change the column, row, detail etc in the wizard combo all the fields change to that setting but the display looks the same.

    Help is useless, it just says to drag the fields to the area where you want them to be but I don't see any different areas, just one blank white space, until I fill it up with columns of data. Once these columns are there the column headers contain lists of tick boxes but none of them will untick or do anything else and the column headers will not drag to anywhere. Nothing else will drag either. I have never seen one of these built so I don't know what I am looking at and cannot tell if the problem is broken software or aged programer causing PEBKAC.


  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Pivot table view (Access 2002)

    Hi David,

    Have you played with pivot tables in Excel? The Access version should look the same. I might suggest trying one in Excel to see if it works differently there. That would at least tell you if your Access installation has some kind of problem.

    Pivot tables allow you to drag columns, i.e., from the top to the side, when you run the pivot table so that the data shifts to a different perspective. Is that where you aren't able to drag, or are you still back in the wizard?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts