Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Combine 2 queries into 1 query

    Hi:

    I have a Union query,
    And, I want to create the table to store Union query results.
    But, there are 2 steps to do.

    How can I combine 2 queries into 1?

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    Know Use the Make table
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I am a little confused because in your question is the answer. To combine the results of two queries into one query you use a Union query. The thing to remember is that each query has to have the same number and order of fields for a Union query to work properly.

    If, on the other hand, that you need to combine two queries into one table, then you can create a table design, then convert the two queries into Append queries. Or make on query a Make Table query and the other one an Append query.

  4. #4
    Join Date
    Sep 2005
    Posts
    313
    I know that
    There are 2 steps.

    I want to use 1 query to do Union and create table.

    Thanks.

  5. #5
    Join Date
    Jan 2005
    Posts
    31
    Quote Originally Posted by accessman2
    I want to use 1 query to do Union and create table.

    Thanks.
    SELECT <whatever>
    INTO <whatever>
    FROM <your union query>

Posting Permissions

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