Prev: calculated field - difficult
Next: divison by zero error
From: John Spencer on 5 Mar 2010 12:08
This will work whether of not there is a comma in the field or not

LEFT([NameField], INSTR(1,[NameField] & ",",",")-1)

It will work for nulls, zero-length strings, and fields that don't contain a
comma, The trick is ensuring that the Instr can always find a comma by adding
a comma to the end of the string.

Null returns "" (a zero length string)
"" returns ""
Spencer returns Spencer
Spencer, JP returns Spencer
de la Hoya, Oscar returns de la Hoya

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Cam wrote:
> Hello,
>
> There is a name field (last, first) in my query that I would like to create
> a new field that only return the last name. What is the proper function to
> use? Thanks
>
> Example:
> Johnson, sam
>
> Return:
> Johnson (without comma)
First  |  Prev  | 
Pages: 1 2
Prev: calculated field - difficult
Next: divison by zero error