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" <b...@REMOVEbcap.THEeuro1net.CAPScomwrote:
It's hard to say from such a vague description, but you're probably going to
need the Iif (immediate if) function.
"marekdec" <marek...@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- Ocultar texto de la cita -
- Mostrar texto de la cita -