PLEASE HELP!!
I'm looking for a way to do a phone book that lists a family's last name, followed by the first name of each member of the family.
I see it in my mind this way:
My end result is a report that will be used as a directory. I have a Family table that indexes families and an individuals table that contains a persons 'Family ID' from the families table. I can use grouping in my report, but I can't get the format I want because the lengths of both the last names and first names change.
Thanks,
jawshark
11th Commandment - Love thy neighbor as thyself
I'm looking for a way to do a phone book that lists a family's last name, followed by the first name of each member of the family.
I see it in my mind this way:
Code:
ADAMS John, Sue, Bill 123-456-7890
CARNEGIE Andrew, Julie, Mabel 123-222-0000
SMITH Heather, Adrian 477-567-9874
My end result is a report that will be used as a directory. I have a Family table that indexes families and an individuals table that contains a persons 'Family ID' from the families table. I can use grouping in my report, but I can't get the format I want because the lengths of both the last names and first names change.
Thanks,
jawshark
11th Commandment - Love thy neighbor as thyself