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.
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.