I have one field that has a comma seperated list. I want to split the list in my query. I found a function below online (Don't recall where, to give credit)
Code:
Function QuerySplit(FieldName As String, Delim As String, Position As Integer)
QuerySplit = Split(FieldName, Delim)(Position)
End Function
Using this syntax if the field only has ONE value it throws an error.
Code:
Field2: Trim(querysplit([Comeon,",",1))
I tried to also check if the 1st location was null
Code:
Field2: IIF(Trim(querysplit([Comeon],",",1)) IS NOT NULL, Trim(querysplit([Comeon],",",1)), "")
However this throws an error as well. How can I use the split function to properly parse this field?