leachj
asked on
How to retrieve multiple name fields in query for label report.
I am using Access 2007.
I have a table of names and addresses for mother, father, step mother, step father, foster parent, guardian and significant other relationships for patients. I need to retrieve the active names and addresses, depending on the family dynamic, to print on mailing labels. I may be overthinking this. Since I can only assign firstname, lastname, address etc to a label, I have in mind to make a create table query to extract the active names and addresses and insert them into generic fields in the created table and use that as the data source for the label report. Then delete the table to be recreated the next time the report is run..
Is this feasable and is there a better way to approach it?
Thanks,
John
I have a table of names and addresses for mother, father, step mother, step father, foster parent, guardian and significant other relationships for patients. I need to retrieve the active names and addresses, depending on the family dynamic, to print on mailing labels. I may be overthinking this. Since I can only assign firstname, lastname, address etc to a label, I have in mind to make a create table query to extract the active names and addresses and insert them into generic fields in the created table and use that as the data source for the label report. Then delete the table to be recreated the next time the report is run..
Is this feasable and is there a better way to approach it?
Thanks,
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeff,
I believe I have the parents designated to receive mailing in my logic. I they are considered a parent pair by us (i.e. mother/father, mother/stepfather, father/sig other etc., there will only be one mailing per address. If there is a divorce and seperate addresses, we chose to select only the person responsible for the patient. We discussed the scenarios you mentioned in detail. The field names in the table are designated as MFname MLname for mother, GFname GLname for guardian etc.
I believe I have the parents designated to receive mailing in my logic. I they are considered a parent pair by us (i.e. mother/father, mother/stepfather, father/sig other etc., there will only be one mailing per address. If there is a divorce and seperate addresses, we chose to select only the person responsible for the patient. We discussed the scenarios you mentioned in detail. The field names in the table are designated as MFname MLname for mother, GFname GLname for guardian etc.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
For the purposes of this database, there is a combobox that allows for entry of 9 possible scenarios for family dynamic, (Father, Mother, Father and Mother, Father and Sig. Other, Mother and Sig. Other, Father and Step Mother, Mother and Step Father, Foster Parent, and Guardian). If 2 are paired, i.e. Father and Mother or Mother and Step Father), only one address will be used for mailing. The mailings will go to the Parents/guardian or foster parent address as this deals with pediatrics and the adult is the target.
ASKER