Hello,
I am trying to split the name field SupervisorName (Bob Smith) into separate fields so I would have "Bob" by itself and "Smith" by itself. here is a pic of my query, I have tryied typing it in, copying it from different websites and nothing is working but I cant see why not... I'm sure its going to be something stupid... but its starting to make me really mad here is what all the examples ive seen are saying the syntax should be
"Left([strName],InStr([strName],” “)-1)"