I am trying to create a query and I am new at programming. A client sent the First Name in a field that is free form and could contain 2 first names that are septerated for either "&" "/" "OR" "AND" in between the names. I need to seperate the names into 2 fields.
For Example the field...