Left ([field_name], InStr(![field_name], " ", 0)-1)
I ran this code successfully on the update to line of my query and got the results I wanted which were to extract the text before the space on my field recordset. Now, I want everything on the other side of the first space of the text.
Anyone know how to modify it?? I cna't remember where I got it, or I would ask that person.