I have a table of clients and a table of accounts for those clients.
Client_Id is a one-many relationship with account_owner.
I want to make a query to be used in a mail merge being sent to clients that lists all of their accounts, but in the queries records it just lists a given client's name once for each account, giving me many records for each client.
Is there anyway to consolidate these into one record with all the accounts listed or manipulate the mail merge system to give me one letter with all the account listed?
Thanks in advance any input.
--Evan
Client_Id is a one-many relationship with account_owner.
I want to make a query to be used in a mail merge being sent to clients that lists all of their accounts, but in the queries records it just lists a given client's name once for each account, giving me many records for each client.
Is there anyway to consolidate these into one record with all the accounts listed or manipulate the mail merge system to give me one letter with all the account listed?
Thanks in advance any input.
--Evan