Count or Group or both

[fileman1]

I hope this will be my last bit of SQL for a while.

I am trying to fill a table with the following

MAIN.ID - JUNCTION1.ID1 KEYWORDS,KEYWORD
19 19 ACCESS,POWERPOINT,WORD
20 20 ACCESS
21 21 POWERPOINT

In other words, it combines a comma separated field containing relevant keywords for each record

 MySql = "SELECT MAIN.ID1, JUNCTION1.ID1, JUNCTION1.ID2, Keywords.Keyword"
 MySql = MySql & " FROM MAIN INNER JOIN (JUNCTION1 INNER JOIN Keywords ON JUNCTION1.KeywordID"
 MySql = MySql & " = Keywords.KeywordID) ON MAIN.ID1 = JUNCTION1.ID1"
 Me!L12.RowSource = MySql

 

[fileman1]

Okay now, did it in VBA. Thanks