Exporting Multiple Orders into excel without Duplicating Client Name

[Aurayai]

Hi all,



I have been Struggling with this problem for sometime, however I am sure that there must be a solution. I apologise if a thread has already been made however I could not find it.

I have a typical table regarding client details: tblClients
Another Table containing Investment orders: tblOrders , of course many orders can be made per client.

What I would like to achieve is some way of exporting this data in to excel with all data regarding each individual client stored in a single record. (This is needed for mail merge purposes)

What i have now:

Client : Bob Fossil Order: Pension
Client : Bob Fossil Order: ISA

What i would like:

Client : Bob Fossil Order: Pension, ISA

Any help or advice would be greatly appreciated!

Thanks in advance!

Chris

[Aurayai]

I have found an Answer to this within Excel, i little more manual but hey the solution is here;

http://www.excelforum.com/excel-gene...n-another.html