Two separate fields need to be grouped in one group
- by Sigita
I have two fields: Mother's employer and Father's employer, and I need to group on the employer. Could somebody help me combine the two above fields into one group?
Both fields are in one table. FOr example a child named John Lewis is a record in a table and he has a father and a mother and Mother's employer is IBM and Father's employer is ISF. And so forth. I need to come up with a list By employer where it would show:
Employer: IBM
John Lewis
Emplyer: ISF
John Lewis
Employer: ....
Thank you,
Sigita