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?