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

Concatenate question

P: n/a
I need to loop thru a table and concatenate values from a field called
"items" and place in a new table with the concatenated values
displaying in one record (grouped by order#). Any ideas ?

Current Example

Order# Items
1 Sausage
1 Cheese
1 Onion
1 Bacon
2 Sausage
2 Peperroni

Requested Output on the report

Order# Items
1 Sausage,Cheese,Onion,Bacon
2 Sausage,Pepperoni

I know this is not normalized, but my users are adamant on the report
displaying as
shown under "Requested Output on the report "

Aug 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

This discussion thread is closed

Replies have been disabled for this discussion.