I have a straightforward address database with:
ID (autonumber)
First Name
Middle Name
Last Name
Address
City
State
Zip
I need to create a query or something to combine first names with last name if the address is the same. Example:
Bob J. Smith 1515 Canopy Lane Hope MI 48642
Linda R. Smith 1515 Canopy Lane Hope MI 48642
So these are two records in the database and I want to create mailing labels, but want it to be addressed as:
Bob & Linda Smith
1515 Canopy Lane
Hope, MI 48642
Can anyone help me with this? I know it can't be too difficult, but I am stumped. THANK YOU!