How to display?

  • Thread starter Thread starter noclue?
  • Start date Start date
N

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
..
..
..
 
Have considered a crosstab query? You could sum the abs() of the yes/no
fields to count the "yes" values.
 
Back
Top