I want to send one letter to the client address and list the Beneficiaries
for that address.
Each Beneficiary is attached to its own Client record. that is how the data
was imported.
I want the address once, and each of the Beneficiaries at that address.
The clients are the parents and the Beneficiaries are the children... the
children's last name may or may not be the same as the rest of the
children...

I have a Client table that look something like this:
ClientID
Firstname
Lastname
Address
City
State
Zip

I have a Beneficiaries table that looks something like this:
BeneficiaryID
ClientID
BeneficiariesFirstName
BeneficiariesLastName

Any ideas would be appreciated.

I'm using Access 2003 if it matters.

Thanks

Kelvin