T
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.
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.