I am combining 2 crosstab queries using a union query. All fields are the same in both. When I run the query, the "Column Heading" and "Value" fields from the source crosstab queries are not recognized. The "Row Heading" fields list as expected. Is there additional SQL that I need to get my other 2 fields to list? My SQL reads SELECT [Field1],[Field2],... FROM [Query1] UNION SELECT [Field1],[Field2],... FROM [Query2]. Any Ideas??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Union Query using Crosstab Queries
- Thread starter BuzzG
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
