If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to send a report to everyone at one address...
"Kelvin Beaton" kelvin at mccsa dot com wrote in
: 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 create the letter as a report, based only on the client table. Create a sub-report using the beneficiaries table, and embed it in the main report using the ClientID field in both the lin parent fields property and link child fields property of the subform control. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
#2
|
|||
|
|||
I want to send a report to everyone at one address...
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 |
#3
|
|||
|
|||
I want to send a report to everyone at one address...
thanks, I'll give it a try!
Kelvin "Bob Quintal" wrote in message ... "Kelvin Beaton" kelvin at mccsa dot com wrote in : 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 create the letter as a report, based only on the client table. Create a sub-report using the beneficiaries table, and embed it in the main report using the ClientID field in both the lin parent fields property and link child fields property of the subform control. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
Thread Tools | |
Display Modes | |
|
|