From: Nova on
This is my table
Field1 Field2
A QQ
A WW
A SS
B RR
B HH
C MM
D FF

I 'd like query result like this

Filed1 FieldNew
A QQ,WW,SS
B RR,HH
C MM
D FF

How to create query?


From: Duane Hookom on
There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16.

Duane Hookom
MS Access MVP


"Nova" <Nova(a)discussions.microsoft.com> wrote in message
news:766EDBDA-7D79-4C1F-9370-34658288280A(a)microsoft.com...
> This is my table
> Field1 Field2
> A QQ
> A WW
> A SS
> B RR
> B HH
> C MM
> D FF
>
> I 'd like query result like this
>
> Filed1 FieldNew
> A QQ,WW,SS
> B RR,HH
> C MM
> D FF
>
> How to create query?
>
>