I have a DB table with records for each person that is part of a church. I am trying to create a query that will combine Family members into one address as follows:
{Head of Household FirstName} {[if married] & 'and' & {spouse firstname}
street address
{City}, {State} {Zip}
{Primary Phone}...