Query Question...

1

116

I have a name field that contains first and last, not seperated. I am
wondering if I can use the MID and LEFT to grab x amount of characters from
the last name?

Thanks in advance
David
 
B

BruceM

Provided there is a space between the first and last names you could do
something like this:
NewField: Left(Mid([SomeField],Instr([SomeField]," ") + 1),4)

However, you could run into problems names such as James Earl Jones or Linus
Van Pelt
 
Top