Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Question Unanswered: Pivot Table Virgin

    okay. i need to take a form from access and, i'm guessing, bring it into a pivot table. i have a form that has advertisers in a catalog with their publication dates, issues and advertisement details. i need to somehow bring that into a pivot table or other set-up with a pull down menu so that i can choose a catalog and see all the corresponding information.
    forgive my "newness", but please offer some help if you can!
    thank you!

  2. #2
    Join Date
    Oct 2003
    Not sure I understand fully, but if you have the Form in Access, it is most likely based on a query.

    In Excel, go to Data > PivotTable, then select "External data" and in the resulting dialog box, choose MS Access, then OK, then navigate to the query underlying the Form. Go through the appropriate dialog boxes, and then finally import the data.

    After that data is set, you can select Layout and position the items wherever you desire (drag and drop). Once you click OK, then you can go to each field and select by dropdown list what you want to see.

    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004

    pivot tables

    it is from a querry in access right now, yes. i will try your directions n yor post. thank you so much for responding.

Posting Permissions

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