Join text within grouping query

[tekkyun]

Hi,
Does anyone know an easy way to join text data within grouping query?
For example, I have data like this:-

Field1 Field2
A Gr1
B Gr1
D Gr2
E Gr2
F Gr2

and would like to get result like this:-

Result1 Field2
A B C Gr1
D E F Gr2

Thanks

 

[dhookom]

Check the FAQs of this forum for the answer.

Duane
Hook'D on Access
MS Access MVP

 

[tekkyun]

Thanks Duane, I did try that but have not found answer. Can you point me to appropriate thread?

thanks

 

[dhookom]

  faq701-4233

Duane
Hook'D on Access
MS Access MVP

 

[tekkyun]

Just the job - works exactly how I need

Thanks again Duane
Mike