String aggregation with SQL

[marekdec]

Hello!

I'm trying to find a way to aggregate string values from a column to
get a long strings separated by commas, based on specified criteria. I
found some solutions on the web though they don't really seem to work
with MS SQL.
Is there any way to do it using pure SQL in MS Access?

Thanks for all the answers!
Marek

[Baz]

It's hard to say from such a vague description, but you're probably going to
need the Iif (immediate if) function.

"marekdec" <ma******@gmail.comwrote in message
news:11**********************@r34g2000hsd.googlegr oups.com...

Hello!

I'm trying to find a way to aggregate string values from a column to
get a long strings separated by commas, based on specified criteria. I
found some solutions on the web though they don't really seem to work
with MS SQL.
Is there any way to do it using pure SQL in MS Access?

Thanks for all the answers!
Marek

[marekdec]

Thanks a lot, however it's not what I'm looking for.

I'm going to put it more clear (sorry about the lack of description).
So the thing is I my table contains a column of string values and a
column of numbers e.g.
"a" 1
"b" 1
"c" 2
"d" 2
One for row.
What I wanna do is to issue an operation that would result in
following:
"a,b" 1
"c,d" 2
In other words I want to concatenate all this letters that stand next
to 1 and all this that stand next to 2.
I'm aware this topic must have been discussed, though I can't find any
solution for Access sql.

I'm kinda newbie to databases that's why my description can be a bit
blurred.
Thanks for your help.
Marek


On 23 jul, 12:11, "Baz" <[e-mail]:

It's hard to say from such a vague description, but you're probably going to
need the Iif (immediate if) function.

"marekdec" <[e-mail] in message

news:11**********************@r34g2000hsd.googlegr oups.com...

Hello!

I'm trying to find a way to aggregate string values from a column to
get a long strings separated by commas, based on specified criteria. I
found some solutions on the web though they don't really seem to work
with MS SQL.
Is there any way to do it using pure SQL in MS Access?

Thanks for all the answers!
Marek- Ocultar texto de la cita -

- Mostrar texto de la cita -

[Baz]

That is indeed a tricky problem, and I can't immediately think of any way of
doing it in "pure" SQL. I think I would create a query which returned the
grouped numeric values, and which called a VBA function to return the column
containing the comma-delimited string.

Which would be neither elegant nor fast, I will be the first to admit!

"marekdec" <ma******@gmail.comwrote in message
news:11*********************@m3g2000hsh.googlegrou ps.com...

Thanks a lot, however it's not what I'm looking for.

I'm going to put it more clear (sorry about the lack of description).
So the thing is I my table contains a column of string values and a
column of numbers e.g.
"a" 1
"b" 1
"c" 2
"d" 2
One for row.
What I wanna do is to issue an operation that would result in
following:
"a,b" 1
"c,d" 2
In other words I want to concatenate all this letters that stand next
to 1 and all this that stand next to 2.
I'm aware this topic must have been discussed, though I can't find any
solution for Access sql.

I'm kinda newbie to databases that's why my description can be a bit
blurred.
Thanks for your help.
Marek


On 23 jul, 12:11, "Baz" <[e-mail]:

It's hard to say from such a vague description, but you're probably

going to

need the Iif (immediate if) function.

"marekdec" <[e-mail] in message

news:11**********************@r34g2000hsd.googlegr oups.com...

Hello!

I'm trying to find a way to aggregate string values from a column to
get a long strings separated by commas, based on specified criteria. I
found some solutions on the web though they don't really seem to work
with MS SQL.
Is there any way to do it using pure SQL in MS Access?

Thanks for all the answers!
Marek- Ocultar texto de la cita -

- Mostrar texto de la cita -