Query Distinct and Concatenation

[anhlongqld]

Please help with the query below, I would like to make it display like the attached image but couldn't work out how to. Thanks.

SELECT tblSONG.CallNo, tblSONG.ID, tblSONG.Title, [tblSONG-ARTIST].Artist, [tblSONG-GENRE].Genre, tblLYRIC.Lyric
FROM tblLYRIC INNER JOIN ((tblSONG INNER JOIN [tblSONG-ARTIST] ON tblSONG.[ID] = [tblSONG-ARTIST].[SongID]) INNER JOIN [tblSONG-GENRE] ON tblSONG.[ID] = [tblSONG-GENRE].[SongID]) ON tblLYRIC.ID = tblSONG.LyricID;

 

[jdraw]

see http://allenbrowne.com/func-concat.html
for ideas