Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query Output with text?

Discussion in 'Information Technology' started by dan, Jul 28, 2006.

Tags:
  1. dan

    dan
    Expand Collapse
    Guest

    Hi,
    Using access, I am using UNION ALL to output two queries. Is there a
    way to get a blank line or some text to be output in the middle of the
    two queries like this:

    Query1
    UNION ALL
    (blank line or Title)
    QUERY2

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Barry Gilbert

    Barry Gilbert
    Expand Collapse
    Guest

    Create a third select statement, something like this:

    Select Field1, Field2, Field3 FROM table1
    UNION
    SELECT null as Field1, null AS Field2, null As Field3 FROM Table1
    UNION
    SELECT Field1, Field2, Field3 FROM Table2

    Barry

    "dan" wrote:

    > Hi,
    > Using access, I am using UNION ALL to output two queries. Is there a
    > way to get a blank line or some text to be output in the middle of the
    > two queries like this:
    >
    > Query1
    > UNION ALL
    > (blank line or Title)
    > QUERY2
    >
    > Thanks!
    >
    >
     

Share This Page