Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab and Union Query (2003)

    Hello,
    I have a general question regarding crosstab queries. I have 2 cosstab queries that I want to make inot a union query. Is this possible and what would be the general syntax?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Crosstab and Union Query (2003)

    You should probably specify the Column Headings properties of both crosstab queries, so that you are certain that they return the same fields (columns) in the same order. You can then create a union query the usual way, e.g.

    SELECT * FROM Crosstab1
    UNION
    SELECT * FROM Crosstab2

Posting Permissions

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