In my database I'm tracking winners and losers for tournaments. I created two separate cross tab queries to count the wins/losses by round and then it has a total column. I figured out how to use a union query to get both wins & losses in one query so I can easily track their record. The part I have a problem with is it has two rows per team, one for losses and one for wins, but there is no easy way to distinguish which is which unless going into the individual cross tabs. Anybody know how to input something to tell which row is the wins and which is the losses? Possibly a column in front that says wins or losses? Thanks
Bookmarks