469,347 Members | 19,743 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Combine multiple rows into one column in MSAccess 2003

Am new to Access so go easy

Each serial number has several comments made for it and what I need is to combine all comments for each serial into one row separated by a comma or l.

Now here are tables:

dbo_tracking for the serial numbers
dbo_comments for the comments

Right now this is what I can display

Serial number Comment
SAB45 comment1
SAB45 comment2
SAB89 comment4
SAB89 comment5

I need

Serial number comments
SAB45 comment1 l comment2
SAB89 comment4 l comment5

Please help.
Apr 9 '08 #1
2 2676
3,532 Expert 2GB
Your duplicate posting of this question/problem has been deleted! Please refrain from this prohibited behavior in the future.

From FAQs

Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

1. It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
2. It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't had any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Thank you for your attention in this matter.

Welcome to bytes!

Linq ;0)>

Apr 10 '08 #2
32,184 Expert Mod 16PB
Check through the following for some hints and tips on this subject.
(Combining Multiple Rows of one Field into One Result)
(Combining Rows-Opposite of Union)
Apr 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by remote89 | last post: by
16 posts views Thread by Tim Davidge | last post: by
14 posts views Thread by imani_technology_spam | last post: by
5 posts views Thread by Antanas | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.