Newbie needs help extracting info from field 1

[ChuckCasey]

I have a table that has a field LASTNAME,FIRSTNAME. I want to be able to extract first initial last name from this (ie: JONES,BOB = bjones). Can someone help this newbie?
Many thanks!

 

[dhookom]

Chuck,
Check Help for the functions Instr(), Mid(), Left()...
Try:
Mid([LastFirst],Instr([LastFirst],",")+1,1) & Left([LastFirst],Instr([LastFirst],",")-1)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[OhioSteve]

The last post is right on target. However, in the long term you need to use multiple fields to hold names. Most db with names use three fields: firstname, lastname, and title.