Pivot/Combining multiple string into one field

[rkruis]

I have three tables, I'll describe my best below.

tblMaster
ID | Model | CommentsIds
1  | ford | 123; 124; 126;
2  | chev | 323; 124
3  | ford  | 111; 124

tblComments
ID   | CommentID
1    | 123
1    | 124
1    | 126
2    | 323
2    | 124
3    | 111
3    | 124

tblCommentDescriptions
CommentID | Commentdescription
123    | "Some string"
124    | "Another String"
125    | "String 3"
126    | "string 4"
127    | "String 5
... continues

I left join tblMaster ID to tblComments ID
I left join tblComments Comments to tblCommentDescriptions CommentID

My result is like this
1 | 123 | "Some string"
1 | 124 | "Another String"
1 | 126 | "string 4"

How can I combine the CommentDescriptions using a query, into one field using tblMaster ID and unique?
Such as
1 | "Some string""Another String""string 4"

[June7]

Review http://allenbrowne.com/func-concat.html

[rkruis]

Thanks June7, however this will not work for me.
I need to use functions that already exist within MS Access and I am creating this on the fly.

Basically I have this. I have one master table, and one child table. I need all of the related records from one column in the child table into one column.
Such as
1, Value 1, Value 2, Value 3
2, Value 1, Value 4, Value 7

1 and 2 a two different records in the master table. Value 1-x are records joined from the chils.

[June7]

If you provide database so I don't have to build tables I will test some ideas. Follow instructions at bottom of my post.

[rkruis]

Take a look at the query (Test)
It returns these results.

1, w/ Tachometer
1, w/ School Bus Package
1, w/o School Bus Package
1, w/ Multi-Stage Damper


I want:
1 , 'w/ Tachometer' 'w/ School Bus Package' 'w/o School Bus Package' 'w/ Multi-Stage Damper' 

Thanks for the help.

[June7]

Consider:

Revise test query:
SELECT Comments.CommentCode, tempPartsProTable.Id, Comments.CommentText
FROM (tempPartsProTable RIGHT JOIN tempPartsProCommentTable ON tempPartsProTable.Id = tempPartsProCommentTable.Id) RIGHT JOIN Comments ON tempPartsProCommentTable.CommentID = Comments.CommentCode
ORDER BY tempPartsProTable.Id;

Query1
TRANSFORM First(test.CommentText) AS FirstOfCommentText
SELECT test.Id
FROM test
GROUP BY test.Id
PIVOT test.CommentCode;

Query2
SELECT Query1.Id, [11] & ", " & [22] & ", " & [33] & ", " & [44] & ", " & [55] & ", " & [66] & ", " & [77] AS Comments
FROM Query1;

[rkruis]

Thanks June7! This works just fine. I would like to be able to not show commas if a field is blank, but that is a later task.