Group part options by part

[asc4john]

I have a few tables describing parts and thier options.
tblParts pNumber and tblOptions with pNumber, option
I do a SELECT FROM query with a join and I get

Part Option
123 A
123 B
123 D
234 A
234 D

Can I get the following using SQL or is this something that needs VBA
code or a combination of both.
Part Options
123 A,B,D
234 A,D

Thanks

[Jason Lepack]

You require this:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%2 0To%20Concatenate%20Child%20Records'

Cheers,
Jason Lepack
On May 31, 1:32 pm, asc4john <[e-mail]:

I have a few tables describing parts and thier options.
tblParts pNumber and tblOptions with pNumber, option
I do a SELECT FROM query with a join and I get

Part Option
123 A
123 B
123 D
234 A
234 D

Can I get the following using SQL or is this something that needs VBA
code or a combination of both.
Part Options
123 A,B,D
234 A,D

Thanks

[asc4john]

On May 31, 11:41 am, Jason Lepack <[e-mail]:

You require this:http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Gene...

Cheers,
Jason Lepack

On May 31, 1:32 pm,asc4john<[e-mail]:

I have a few tables describing parts and thier options.
tblParts pNumber and tblOptions with pNumber, option
I do a SELECT FROM query with a join and I get

Part Option
123 A
123 B
123 D
234 A
234 D

Can I get the following using SQL or is this something that needs VBA
code or a combination of both.
Part Options
123 A,B,D
234 A,D

Thanks

Thank you it seems to do what I need.