My data is college course sections that have many course-type codes. The goal is to give each section a single label that tells whether the course is taught online (ONLN), face-to-face (F2F), blended (BLL), or remote (REM). Most course type codes are not relevant to how the course is taught but serve other purposes.
In the sample data below, you can see that the course section ENG_101_WW has the course type ONLN. That means it's taught online and should be labeled "Online."
ENG_101_1A has the code "BLL" and should be labeled "Blended."
ENG_101_2B has "REM" and should be labeled "Remote."
Finally, ENG_101_3C has none of these codes. That means it's taught in the default, face-to-face manner and should get the "F2F" label.
Course Section Course Type
My desired result is:
What I've been doing is passing each course section ID (e.g. ENG_101_WW) to a VBA function that uses a DAO recordset to query all its course type codes, loop through the codes, and assign the appropriate label (Online, Blended, Remote, and F2F when none of the relevant codes are found). While this works, it's painfully slow, and I'm hoping you can suggest a more efficient way to get the desired result.
What would you recommend?