Combining records for mailing labels

[gddrew]

I am new to Access and programming in general. I hope someone can answer my question regarding combining two or m ore records into a single mailing label.

I maintain a membership database. In this database there can be a separate record for two individuals who live at the same home address.

Example:

 LST_NM      | 1ST_NM       | STR_ADR
------------------------------------------------
 Smith       | James        | 123 Main St
------------------------------------------------
 Smith       | Mary         | 123 Main St
------------------------------------------------
 Smith       | William      | 456 Elm St
------------------------------------------------

In the above example, James and Mary Smith are husband and wife and live at the same address. Separate records are created for legitimate reasons; combining into a single record in the DB is not a viable option.

My question is: is it possible to maintain separate records for James Smith and Mary Smith, while at the same time creating a single mailing label for James and Mary Smith. If so, how would I do that?

If it has to be done programmatically, a code sample would be greatly appreciated.

 

[MisterC]

When you create your query, just group by STR_ADR. --------------
A little knowledge is a dangerous thing.

 

[gddrew]

But they're still separate entries....