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

Child Values in One Field?

P: n/a
This is probably more SQL help, but I am trying to pull a record and it's
children for formatting. Is there a way that I can put all child values in
one field? For example Product A has five Features in a separate table
joined by Product ID. I want one field that will output "Product -
Feature1, Feature2, Feature3, Feature4, Feature5."

Is this possible?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Simplest solution is to use a VBA function to return a string containing the
child records delimited with a comma.

Details:
http://www.mvps.org/access/modules/mdl0004.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Erin Welsh" <el****@yahoo.com> wrote in message
news:L%*******************@bgtnsc04-news.ops.worldnet.att.net...
This is probably more SQL help, but I am trying to pull a record and it's
children for formatting. Is there a way that I can put all child values
in one field? For example Product A has five Features in a separate table
joined by Product ID. I want one field that will output "Product -
Feature1, Feature2, Feature3, Feature4, Feature5."

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.