Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot Table from Access

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would like to create a pivot table from a query in Access. However when I connect to the query through the wizard, it won't let me run the query. If I try to run the query I just get a beep, no error message. If I try to add a filed from the Access query to MS Query I get an error message that reads "Too few parameters. Expect 1". My Access query is actually a summary query of another query that retreives the detail data I need for the summary. In addition the detail query in Access has one parameter it prompts the user for. Is this type of query unusable for MS Query? Can I build a multi-level query in MS Query like the one I have in Access (although I hate to duplicate the effort)? Is it better to bypass MS Query and use VBA in some way to connect to the tables or Access query and run the query?

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The parameter in the query is what's causing your problem. You could use VBA to set up your pivot table, and could use an InputBox to ask the user for the parameter value.

    -RH

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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