Access to PowerPoint - How to output an Access lookup field to PP?

[frogman123]

I have an Access query which has text fields except for one, a field (number) which is based on a lookup table.

The code below works well to put the contents of a text field into my PowerPoint table.

.Cell(lngY, lngX).Shape.TextFrame.TextRange.Text = RSTravelSch_DTRI_ABS_Query6.Fields("Attendees").Value

However, when I try to put the content of "Attendees" into the table I get a type mismatch error. This is due to Attendees being of type 104 (ComplexLong .. aka a Number, not Text).

In access, this field is a pull-down where you can select multiple attendees for a single event. The table field is a standard lookup table

SELECT Attendees.[ID], Attendees.LastName, Attendees.FirstName FROM Attendees ORDER BY Attendees.LastName;
 

I just can't figure out how to output (from Access to PP) the list of names for each event.

For example: "Jones, Smith, Carloson, Robinson"

Help!!

[frogman123]

So this is called, in Access, a Multi-value Field. Trying to figure out if I can avoid this usage or what the work around is to turn a Multi-value field to text.

Any thoughts?