grouping in query

[cbeshears]

I have a database of names and address that I want to use to create mailing labels; however, I am having a problem.

I may have an entry for Bob Smith at 123 Main Street, City, ST 12345.
And I may have an entry for his wife, Sue Smith, at 123 Main Street, City, ST 12345.

In my query, (when the conditions are met), I would like for the label to display the following:

Bob and Sue Smtih
123 Main Street
City, ST 12345

How do I do this? I tried to google it, but the information I'm finding does not address my problems. Thanks for your help in advance.

[fenway]

First, you need to decide how you're going to define an match -- exact, fuzzy, etc.  Once you've done that (easier said that done), you can work on the output.