Combine all states into one field

[DSburgh]

[MachineXREF] table contains a field for [State] and [Distributor].

I need to make a query to return the [Distributor] and all the states in a single field. For Example:
DistA: NC,PA,OH
DistB: NC,SC,WV
and so on.

How do I go about this?

 

[PHV]

And what about have a look in the FAQ area ?

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

 

[DSburgh]

That module works great. I modified the example code to work where the primary key is a string. Would it be worth adding to the FAQ?

'SELECT FamID,
'Concatenate("SELECT FirstName FROM tblFamMem
'WHERE FamID = """ & [FamID] & """)") as FirstNames
'FROM tblFamily

Thanks again.