I'm using Allen Browne's ConcatRelated. This is the sql string.
SELECT tblMain.MnIdNum, tblMain.SortName, ConcatRelated("Phone","qryPhones","MainID_FK=" & [MnIdNum],""," | ") AS P
FROM tblMain;
I'm not sure where to actually use either vbCrLf or Chr(13) & Chr(10)