Running Concat Query

[mordja]

Hi,

I can do a running sum in sql but can you do similar with a string.

I have a table with two colums, AllocationType, Category both text.

Ie
AllocationType Category
External IND
External ING
External CEC
Internal CEC
Internal DED

I would like the query to return

External IND; ING; CEC;
Internal CEC; DED;

Is it possible in SQL or can it only be done in VBA ?

THanks

MOrdja

 

[PHV]

I strongly recommend a look in the FAQ area.

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

 

[dhookom]

faq701-4233

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]