Left, LTrim, or what

I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Hopefully your field values are consistent.

Feel free to open a module and search Help on Left, Mid, Instr. You should
be able to figure out the syntax. If not, come back with "a field" name.

--
Duane Hookom
MS Access MVP
--

"JWCrosby" wrote in message
...
I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Use:
- Instr() to locate the comma,
- Mid() to get the remainder of the field,
-Trim() to deal with the space.

So, assuming a field named FullName, the FirstName would be:
Trim(Mid([FullName], Instr([FullName], ",") + 1))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JWCrosby" wrote in message
...
I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

"JWCrosby" wrote in message
...
I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Perhaps:

Left([FullName], Instr([FullName], ",") + 2)

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Yours did it, Randy. Thanks!

Jerry

"Randy Harris" wrote:


"JWCrosby" wrote in message
...
I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Perhaps:

Left([FullName], Instr([FullName], ",") + 2)

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.