Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CrossTab Query - Make table with results (2000)

    I am having trouble trying to figure out how to make a table from a crosstab query. It does not seem I can put an INTO clause in the SQL. Suggestions?

    Richard

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

    Re: CrossTab Query - Make table with results (2000)

    You can't use a crosstab query to make a table directly. Instead, create a new query based on the crosstab query, and turn the new query into a make table query.

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CrossTab Query - Make table with results (2000)

    Hans,

    How do I create a new query based on another? Is there a way to call another query within a query? If so, how?

    Thanks,

    Ricahrd

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

    Re: CrossTab Query - Make table with results (2000)

    If you click "Create query in design view" in the Queries part of the Database window, you'll be presented with a dialog titled "Add table". This dialog has three tabs: Tables, Queries and Both. Activate the Queries tab, select the crosstab query you designed and click "Add". You can now drag * to the query grid, and turn the query into a make table query.

  5. #5
    New Lounger
    Join Date
    Jul 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CrossTab Query - Make table with results (2000)

    Thank you Hans!

Posting Permissions

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