Query string value between certain commas

[Jason]

I have a table named "Class_Length_Tbl" with field "PeriodLength". PeriodLength has 5 values that are comma separated. I would like to create 5 queries that each return the value in the respective location in the sting of values. Example below:
Sample Data:
Field: PeriodLength
Value1: 0,Full,0,Half,0
Value2: Full,Half,Half,0,Full




Desired outcome:
Value1 results
Query 1 would return 0Query 2 would return Full
Query 3 would return 0
Query 4 would return Half
Query 5 would return 0

Value2 results
Query 1 would return FullQuery 2 would return Half
Query 3 would return Half
Query 4 would return 0
Query 5 would return Full

[Minty]

You need to use the Inst() or Split() function to return the respective result from the string.

Review https://access-programmers.co.uk/for...d.php?t=201907 for some methods