Concatenate a sub table data (1 Viewer)

ECEK

Registered User.
Local time
Today, 10:33
Joined
Dec 19, 2012
Messages
717
I have a list of clients with remuneration. This figure can have a percentage split which is housed in a linked table.

Table1
001,Client1,£100

SplitTable
001,Benefactor1,60%
001,Benefactor2,40%

How would I set a query that concatenates the SplitTable data into a notes field?
ie.

Query1
ID Client £ Split Notes
001,Client1, £100, "Benefactor1 60% Benefactor2,40%"

Thanks for your thoughts.
 

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 06:33
Joined
Oct 17, 2012
Messages
3,276
Assuming there can be any number of splits, you don't. You make a function that concatenates the associated records, then call that in your query. (EDIT: Like the one Minty posted while I was still typing!)

That can be REALLY slow, however.

Why precisely are you doing this? If we know that, we can often come up with a better approach or a work-around for you.
 

ECEK

Registered User.
Local time
Today, 10:33
Joined
Dec 19, 2012
Messages
717
Thanks Guys
Minty's solution has worked perfectly.
Many thanks indeed
 

Users who are viewing this thread

Top Bottom