multiple cell in same column join in one 1

[aleathiel2005]

Hi all,

I'm trying to make up a field from multiple row. Here is an exemple:

Driver Route
DR1 138
DR1 140
DR2 200
DR3 200
DR3 150
DR3 160


I would like to have all route for the same driver on the same cell, like:

Driver Route
DR1 138-140
DR2 200
DR3 200-150-160


Is there a way to do something like that?

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[aleathiel2005]

My SQL is like this:

SELECT [BOL DATABASE].DATE, [BOL DATABASE].DRIVER, Left([SHIPPING_INSTR],3) AS SHIPPING3
FROM P_SO_MASTER_HEADER INNER JOIN [BOL DATABASE] ON P_SO_MASTER_HEADER.CUST_CODE = [BOL DATABASE].ACRONYM
GROUP BY [BOL DATABASE].DATE, [BOL DATABASE].DRIVER, Left([SHIPPING_INSTR],3)
HAVING ((([BOL DATABASE].DATE)=[Forms]![calcul du transport].[DateCalcul]) AND ((Left([SHIPPING_INSTR],3)) Like '###'));

How can I add the concatenate in all that?

 

[aleathiel2005]

I forgot to tell that this is already a query that get is iformation from 2 table.

And thanks a lot PHV!!!

 

[lespaul]

have another look here FAQ701-3499



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design