Access Query: Field Code Help

[Garrett]

Here are examples of my field data.

MARTIN SMITH/1880681/ITD/FED
JACK JACKSON
and I also have null values

When I do my make table query I need it to do the following.
If Null (or blank) put in the word "NONE"
Otherwise all I need are the first and last name.

Here is what I have so far but errors due to some names not having the "/" in them.

TeamManager:If(IsNull([gWEBFollowUpResponsibility]),"NONE",Left([gWEBFollowUpResponsibility],InStr([gWEBFollowUpResponsibility],"/")-1)

Thanks for any help
Garrett

[si_the_geek]

In that case try using an extra If, eg:

If(IsNull([gWEBFollowUpResponsibility]),"NONE",If(InStr([gWEBFollowUpResponsibility],"/")>0,Left([gWEBFollowUpResponsibility],InStr([gWEBFollowUpResponsibility],"/")-1))