Change Query Data Format

[naobao]

How to use modules to convert query from A format to B format?

A Format
101001 A2
101001 A8
101001 C1
101001 D12
101002 B12
101002 C1
101002 J10

change to...B format
101001 A2, A8, C1, D12
101002 B12, C1, J10

Thanks!

 

[isladogs]

Hi naobao
See if the attached crosstab query is any use to you.
If not, then it will need the use of vba.

 

[Minty]

Have a look at Allen Browne's concat related function here: http://allenbrowne.com/func-concat.html

 

[naobao]

Hi naobao
See if the attached crosstab query is any use to you.
If not, then it will need the use of vba.

I have many records in query, crosstab is too many fields...
I think vba is good to me.

Thank you so much!

 

[Gasman]

I'd be looking at Minty's suggestion?