Myriad_Rocker
Questioning Reality
- Local time
- Today, 18:53
- Joined
- Mar 26, 2004
- Messages
- 166
I did a search on "if exists" and didn't come up with a solution for this problem. I have a crosstab query that takes the teams from a table and adds up all the instances of that particular team name. Red, Green, and Blue.
However, there are not always instances of all teams. So, sometimes the crosstab will return Red and Green but not Blue because no Blue's exist.
In a later query, I take this crosstab in as a source and try to add up a total and can't because Blue doesn't exist.
Any way I could get around this without creating a temp table and appending the results from the crosstab to it?
However, there are not always instances of all teams. So, sometimes the crosstab will return Red and Green but not Blue because no Blue's exist.
In a later query, I take this crosstab in as a source and try to add up a total and can't because Blue doesn't exist.
Any way I could get around this without creating a temp table and appending the results from the crosstab to it?