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

    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,275
    Know Use the Make table
    hope this help

    See clear as mud


    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
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE

  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
  •