By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,390 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,390 IT Pros & Developers. It's quick & easy.

Group part options by part

P: n/a
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

May 31 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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 <j...@kinnear.cawrote:
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

May 31 '07 #2

P: n/a
On May 31, 11:41 am, Jason Lepack <jlep...@gmail.comwrote:
You require this:http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Gene...

Cheers,
Jason Lepack

On May 31, 1:32 pm,asc4john<j...@kinnear.cawrote:
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.

Jun 1 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.