J
Joe Leon
I have a table that has columns TeamMember, ShirtSize, BlueShirt, WhiteShirt,
RoseShirt
The following is what the what the tlbMember would look like:
TeamMember ShirtSize BlueShirt WhiteShirt RoseShirt
Yes Small Yes No No
Yes Large No Yes Yes
No X-Large No No No
Yes XX-Large No No Yes
Yes Medium No No No
Yes Large No No No
Yes XX-Large No No Yes
Yes XX-Large No No No
The query I need to create will only give the number of shirts needed for
the TeamMember with Yes. The shirts marked with No are the ones needed.
So the results of the Query would look like the following:
ShirtSize CountOFBlueShirt CountOFWhiteShirt CountOFRoseShirt
Small 0 1
1
Medium 1 1 1
Large 2 1
1
X-Large 0 0 0
XX-Large 3 3 3
Thanks, Joe...
RoseShirt
The following is what the what the tlbMember would look like:
TeamMember ShirtSize BlueShirt WhiteShirt RoseShirt
Yes Small Yes No No
Yes Large No Yes Yes
No X-Large No No No
Yes XX-Large No No Yes
Yes Medium No No No
Yes Large No No No
Yes XX-Large No No Yes
Yes XX-Large No No No
The query I need to create will only give the number of shirts needed for
the TeamMember with Yes. The shirts marked with No are the ones needed.
So the results of the Query would look like the following:
ShirtSize CountOFBlueShirt CountOFWhiteShirt CountOFRoseShirt
Small 0 1
1
Medium 1 1 1
Large 2 1
1
X-Large 0 0 0
XX-Large 3 3 3
Thanks, Joe...