I would like to use an update query, with the '*Like*' formatting to update column entries that have a component of the main category I am updating to.
IIf([Event] In ("*Walk*"),"Walking",IIf([Event] In ("*Out*"),"OUTDOORS"))
So anything that has 'walk' will be updated to main category 'WALKING' (i.e. Walking, Walkout, Walkathon. This applies to anything with out, will be updated to main category "OUTDOORS."