Combine multiple rows into one column in MSAccess 2003

[kagweh]

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.

[missinglinq]

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)>

Moderator

[NeoPa]

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)