Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot table (2003)

    I have a query that has 63 K records. I am trying to create a pivot table view from the query. I have 13 fields for the row - no problem putting those in. I have 15 detail. When I try to sum each of the detail, I get "No details. The query could not be processed. o Query Cancelled. Press F9 to restart the query and desplay data. Is there a limitation to the number of rows and detail fields that you can use? I created another pivot table that has 32K records, 7 rows and 9 detail fields and it works fine.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot table (2003)

    I couldn't find any information on this, but I'm not suprised - do you really need 15 data fields? <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    Perhaps you should reconsider your approach - the purpose of a pivot table is to summarize data in an easily readable format, but 13 row fields and 15 data fields hardly make for a readable result.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table (2003)

    I am trying to create a pivot table like I did just yesterday. It says that when you drop the fields in the detail area, they come in as detail but mine are coming in summing. I had to highlight the columns and then use the sigma to sum the columns but today I am (I think) doing the same thing and the columns are coming in as summing instead of detail. Anyone know what I am doing wrong today that I seemed to have done right just yesterday???

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot table (2003)

    I've given up on pivot tables because of their unpredictable and recalcitrant behavior.

Posting Permissions

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