C
catgirl
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
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