Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Make Table or Name Table From UNION ALL Query

    This query work flawlessly.

    Is there a way to either rename, or Make Table from this query?

    Code:
    SELECT [TblCARETSDataPEND&CLOSD].*
    FROM [TblCARETSDataPEND&CLOSD]
    
    UNION ALL
    SELECT TblCARETSDataACTIVES.*
    FROM TblCARETSDataACTIVES;
    Thanks.

    Rick

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    502
    Okay - I found it searching on the Web.

    Here is the link: ACC2000: How to Create a Make-Table Query with a Union Query This link is optomized for IE of course!

    Basically you create the UNION ALL query first - save it.

    Then create another query based on the FIRST saved query.

    Change the second query to a MAKE TABLE query and there you have it.

    Save the second query.

    Please see the link. Hope this helps someone.

    Rick
    Last edited by Rick Schreiber; 05-22-09 at 17:54.

Posting Permissions

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