Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    pivot table display (Access 03 SP2)

    Edited by HansV to present data in table format

    I know this is the STUPIDEST question, but i really don't feel like looking in a book to figure out why I'm so dumb on this! Why do my pivot tables display differently? I want everything setup like the bottom sample, but i can adjust the settings. is there a simple switch?

    <table border=1><td>month</td><td>Data</td><td>Total</td><td>DEC</td><td>Sum of <30</td><td align=right>0</td><tr><td align=right>
    thanks
    christine

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

    Re: pivot table display (Access 03 SP2)

    In the first example, both Month and Data have been placed in the Row Fields area. You should drag Data to the Column Fields area at the top of the pivot table.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> PS You haven't provided any feedback to your previous questions - that way, other Loungers don't know whether the replies were helpful. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table display (Access 03 SP2)

    That's why this question is so crazy. I've tried that one before. Both setting are exactly the same.
    thanks
    christine

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

    Re: pivot table display (Access 03 SP2)

    You have asked this question in the Access forum. Your attachment is an Excel file. What's going on?

  5. #5
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table display (Access 03 SP2)

    Because I'm a moron! I keep forgetting where I'm at because I linking up to an access database. Sorry...again! Should I close this one out and open a new post in Excel?
    thanks
    christine

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

    Re: pivot table display (Access 03 SP2)

    I've moved the entire thread to the Excel forum.

    Have you actually tried dragging the grey 'Data' button to where Total is now and dropping it there?

  7. #7
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table display (Access 03 SP2)

    Oh my goodness. I knew it was something SIMPLE that I couldn't figure out. Thanks once again!
    thanks
    christine

Posting Permissions

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