How to use a loop?

[noclue?]

How to use a loop?

I had problem querying the number of yes or no, to a table?

I need to display a table based from the 3 fields from a
table(branchinfo). Say 'area','team' and 'QC'.
QC is the yes or no option.

How can I dislay the table showing like 'area' on x-axis,
and 'team' on y-axis and the count of 'QC' as the
data


eg
districtA districtB districtC districtD
team A 4 3 1 1
team B 2 1 2 3
team C 1 4 3 1
...
...
...


..

 

[Gary Walter]

Did you try a crosstab query?

TRANSFORM Abs(Sum([QC])) As YesCount
SELECT team
FROM branchinfo
GROUP BY team
PIVOT area

TRANSFORM Abs(Sum([QC]=0)) As NoCount
SELECT team
FROM branchinfo
GROUP BY team
PIVOT area