Page 1 of 1

Making a custom mailing label using queries

Posted: Sun Oct 11, 2009 5:00 pm
by cdengert
I would like to print labels that have the children's names on it and where there are multiple children in a family, I want the label to read 'The Smith Children' instead of 'The Smith Family', and where there are multiple last names within the family of children, I want the label to use the household key's last name (the default seems to be the last name of the oldest child). Can this be done? If the answer is 'yes, but only by making a custom report', please give me step-by-step instructions on how to do that. I know a little bit about queries, but the wizard didn't seem to have the correct operators and some of the options didn't make sense to me. So please be specific.