Union query to join two crosstab queries

[racefan91]

I have a table that has columns for two teams that play each other, a column for the winner, and a column for the loser. I then made two cross tab queries calculate winners and losers. I joined these two cross tab queries using a union query but there is no way to tell which rows came from which cross tab query. Is there some way to accomplish this? Attached are pictures for my table, the two cross tab queries and the union query.




This is the sql for the union query
SELECT *
FROM [Qry_Matchups_Losses by Round-Crosstab]
UNION SELECT [Qry_Matchups_Wins by Round-Crosstab].*
FROM [Qry_Matchups_Wins by Round-Crosstab];

[JoeM]

How about something like this?

SELECT [Qry_Matchups_Losses by Round-Crosstab].*,"Losses" as Query_Source
FROM [Qry_Matchups_Losses by Round-Crosstab]
UNION 
SELECT [Qry_Matchups_Wins by Round-Crosstab].*,"Wins" as Query_Source
FROM [Qry_Matchups_Wins by Round-Crosstab];

[racefan91]

I get an error saying "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

[racefan91]

Figured it out by removing the comma after Query Source

[JoeM]

Oops, sorry about that typo. I have gone back and corrected it.

[racefan91]

Thanks a ton for the help!