Look up Crosstab queries

This can be done with difficulty.

What you really need to do is to store the values in a table with one row
for each of the values.

What is the maximum number of values that might be stored.

I would use a custom vba function to do this.

SELECT getSplit([MultiField],0) as TheFirst
, getSplit([MultiField],1) as TheSecond
, getSplit([MultiField],2) as TheThird
, getSplit([MultiField],3) as TheFourth
FROM YourTable

"UNTESTED FUNCTION follows.  Copy and paste this into a VBA module and save
it.
Public Function getSplit(TheString, iPos)
Dim vAr as Variant

   If Len(TheString & "") = 0 Then
     getSplit = Null
  Else
     vAr = Split(theString, ",")
     If iPos <= UBound(vAr) Then
        getSplit = vAr(iPos)
    Else
       getSplit = Null
    End if

End Function