Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    4

    Red face Unanswered: Access Report and Multiple Query Problem

    Hi Everyone,
    I have 2 queries which produce the same column structure
    i.e
    Queary one
    Team ID , Full Name
    -------- ---------
    -------- ---------
    -------- ---------
    -------- ---------
    -------- ---------

    Queary two
    Team ID , Full Name
    -------- ---------
    -------- ---------
    -------- ---------
    -------- ---------
    -------- ---------

    Here the Team ID is same for both queries
    What i want is to show both result sets one after the other in a single report
    how can i do this?
    Thank you very much

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    SELECT [Team ID], [Full Name]
    FROM [Queary one]
    UNION ALL
    SELECT [Team ID], [Full Name]
    FROM [Queary two]
    ?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2010
    Posts
    4
    OMG
    I forgot that union
    Thank you very very much for helping me,

    By the way I have another problem related to same query

    I have another 2 similar query like like in the previous one. So its like this

    Query1 UNION Query2
    =
    [Team ID] , [Full Name]
    ----------------------
    ----------------------
    ----------------------

    Query3 UNION query4
    =
    [Team ID] , [Full Name]
    ----------------------
    ----------------------
    ----------------------

    But the difference here is that, team IDs are different from the previous 2 queries.

    How can i show it in the report in the following way

    [Team ID 1]
    [Full Name]
    -----------
    -----------
    -----------
    -----------


    [Team ID 2]
    [Full Name]
    -----------
    -----------
    -----------
    -----------

    I can do it for the first 2 queries, but how to do it for the other 2 queries following the above shown structure

Posting Permissions

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