query to change the layout of a table

[Fuzuy]

I have a table has the following layout and about total of 3600
records:

ID# group dwgs spec
1 Arc A-A-0001 01400
1 Mec A-B-0003 01401
1 Fpn A-A-0002 05012
1 Elc A-C-0002 07801
2 Arc A-A-0003 01404
2 Civ A-C-0008 01441
3 Plu A-F-0005 09000
3 Ins A-I-0001 06000

I have to get that Table layout change into the following form, how to
use query/queries to handle it?


ID# group
dwgs spec
1 Arc, Mec, Fpn, Elc A-A-0001, A-B-0003, 01400,
01401,
A-A-0002, A-
C-0002 05012, 07801
2 Arc , Civ A-A-0003 , A-C-0008
01441, 01404
3 Plu , Ins A-F-0005, A-
I-0001 09000, 06000

Help! Thank You!

 

[pietlinden]

I have a table has the following layout and about total of 3600
records:

ID# group dwgs spec
1 Arc A-A-0001 01400
1 Mec A-B-0003 01401
1 Fpn A-A-0002 05012
1 Elc A-C-0002 07801
2 Arc A-A-0003 01404
2 Civ A-C-0008 01441
3 Plu A-F-0005 09000
3 Ins A-I-0001 06000

I have to get that Table layout change into the following form, how to
use query/queries to handle it?

ID# group
dwgs spec
1 Arc, Mec, Fpn, Elc A-A-0001, A-B-0003, 01400,
01401,
A-A-0002, A-
C-0002 05012, 07801
2 Arc , Civ A-A-0003 , A-C-0008
01441, 01404
3 Plu , Ins A-F-0005, A-
I-0001 09000, 06000

Help! Thank You!

You don't. Use fConcatChild from www.mvps.org/access the code is in
the Modules section.