Count Field Contents

[Ty Archer]

Hello, I have four fields call Team1, Team2, Team3 & Team4. Each of the
fields are linked to a lookup table that has 22 team names. The database
consist of people that can be a part of up to four team. I wish to create a
report that list all 22 teams and the amount of people in each team. I have
no problem creating a report that groups by one team field, however, my
problem is how do I do it with the four team fields. Thanks for any help
you can provide.

 

[KARL DEWEY]

How do you plane to differentiate the teams and use to divide the 22 teams
into 4 teams?

 

[Ty Archer]

Karl,

Thanks for the response. After posting, I did a lot of searching and came
across something that worked. I had to create a control field in the footer
of the report that had the following:

Sum(IIf([Field1]='Team1',1,IIF([Field2]='Team2',1,IIF([Field3]='Team3',1,IIF([Field4]='Team4',1,0)))))

I had to create 22 of these fields. Though lengthy, it certainly worked.