How to query

[Nova]

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?

 

[Duane Hookom]

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