Tom Crowfoot
asked on
Joining results into one cell ...
Dear Experts,
I have a database which links tradesmen to trades. The link is done through a table called TradeLinks (attached) which has the following numerical fields:
LinkID
TradesmanID
TradeID
I need a query which will return the TradeIDs consolidated in one cell against each TradesmanID. The results should be separated with a forward slash or maybe a colon
e.g. (numbers picked at random!)
TradesmanID Trades
1 1/5/77/86/140
2 6/20/92/140/163/226
3 25/36/38/112
4 36/50/64/138/140
5 50/101/126/139
6 151/190/200/241
The data stats are as follows: There are 25,000 odd tradesmen and 200 trades. The maximum number of TradeIDs against any TradesmanID is 12. I have attached an Excel export of the table if it helps
Can anybody help
TradeLinks.xlsx
I have a database which links tradesmen to trades. The link is done through a table called TradeLinks (attached) which has the following numerical fields:
LinkID
TradesmanID
TradeID
I need a query which will return the TradeIDs consolidated in one cell against each TradesmanID. The results should be separated with a forward slash or maybe a colon
e.g. (numbers picked at random!)
TradesmanID Trades
1 1/5/77/86/140
2 6/20/92/140/163/226
3 25/36/38/112
4 36/50/64/138/140
5 50/101/126/139
6 151/190/200/241
The data stats are as follows: There are 25,000 odd tradesmen and 200 trades. The maximum number of TradeIDs against any TradesmanID is 12. I have attached an Excel export of the table if it helps
Can anybody help
TradeLinks.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER