grouping & sorting

[Guest]

Hello.
I have a report and are using three groups and four sorts. Its about students living in housing but maybe affiliated with another house. The fields are [house] and [other].

First I group on on the name of the Building (ascending) this is where all the students live.
Second I group on the sex of the student (ascending)
Third I am trying to group on the affiliated house, but here is the kicker, I only want to group into two sections, building=affiliated and building <>affiliated
Last I sort on the students name.
If I just do a group on the affiliated house there are several that don't match the building and I just want all those that don't match to be together.
Can anyone help me please??
Thank you

 

[Joseph Meehan]

Hello.
I have a report and are using three groups and four sorts. Its about
students living in housing but maybe affiliated with another house.
The fields are [house] and [other].

First I group on on the name of the Building (ascending) this is
where all the students live.
Second I group on the sex of the student (ascending)
Third I am trying to group on the affiliated house, but here is the
kicker, I only want to group into two sections, building=affiliated
and building <>affiliated
Last I sort on the students name.
If I just do a group on the affiliated house there are several that
don't match the building and I just want all those that don't match
to be together.
Can anyone help me please??
Thank you

How about adding a query that has a new field defined something along
the line of IIF Building=affiliated value= 0, building<>affiliated value=1