Sending one letter to one family

[aman]

Hi All

I have many records in a query in ms access where there is a contact at address x in one record and then I have another contact that is also at address x (spouse) in a different record.

I have to send letters to the families every month. If more than one member of the same family is in the database then many letters are sent to the same family .
But what I want is " To send one letter to one family in the following format :
Mr and Mrs Smith
22,Conygre Grove
Bristol
Uk.

Could you please put me in the right direction how can i solve this.
My database is in MS Access and 2 or more records of the same address are in the database.

 

[dealwi8me]

I'm not sure if i understood right but i'll try

You can have the records in a query group by the address and also get the count of the address (how many times one address appears in the database) .
Then write an if statement in the query Expression1:if count(address)>1;("Mr & Mrs "&[Surname]);[FirstName]&" "&[Surname]).
Finally you can add in your report the Expression1 field.