I have an export from a program that I cannot control that I lumps to very important datasets into delimited text in one field.
This is project schedule with “Activities“ that are also dependent on other activities being completed before they start, finish, etc.
Wanting a report that shows the subject activity with the predecessor activities below it. I just cannot get that data split apart from the one field as there are sometimes 1 predecessor or there can be several predecessors.

Any help would be awesome
Table One: “Activities”
ActivityID (pk)
ActivityName
Bunch of other stuff.
Pred_Details (delimited field)
FACN-1040: FS, FACS-1040: FS, FACE-1040: FS
Fk_Activity ID before the colon, the relationship type is after
Fk_relaptionshipCode is after the colon/space and then the comma is the next record.
Looking to break this into a query/table
Activity IdRelationship
FACN-1040FS
FACS-1040FS
FACE-1040FS
This would allow me to do a sub report showing all of the predecessors to any one of the activities on the schedule. Plus a bunch more data analysis that I could do.
Any help would be super appreciated, I have seen a video before that showed this but I cannot find it. I can do most of it in Power BI but Access is what I use the most and I would rather this be a VBA process so that I can get the data/reports that I would like.
Thank you very much for reading…..