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.

Does this have anything to do with Outlook?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Ty Archer" <(E-Mail Removed)> wrote in message news:180032FE-9814-4A38-AD95-(E-Mail Removed)...
> 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.

Oooppss, sorry I meant to post this at Access site.

"Sue Mosher [MVP-Outlook]" wrote:

> Does this have anything to do with Outlook?
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
> "Ty Archer" <(E-Mail Removed)> wrote in message news:180032FE-9814-4A38-AD95-(E-Mail Removed)...
> > 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.
>