This newsgroup supports Microsoft Access, the relational database.
You've piqued my curiosity, though. It sounds like you are asking something
like "how do I send a letter addressed to 'Resident'" -- if you don't
disclose, how do you know to whom you are sending?
Regards
Jeff Boyce
Microsoft Office/Access MVP