FULL_NAME conversion

  • Thread starter Thread starter OMS
  • Start date Start date
O

OMS

Hi,
I have a table FULL_NAME with Last, First name ie. Doe, John

Would like it to appear in the report as Doe, J.

I know I should know this but... any help is most appreciated.
Thanks,
 
OMS said:
Hi,
I have a table FULL_NAME with Last, First name ie. Doe, John

Would like it to appear in the report as Doe, J.

I know I should know this but... any help is most appreciated.
Thanks,
Click to expand...

Left(FULL_NAME ,InStr(1, FULL_NAME , ",") + 1) _
& Mid(FULL_NAME, InStr(1, FULL_NAME , ",") + 2, 1)
 
Hi Rick,

Thanks for the quick response. I did have to modify it slightly but you got
me there.

Left([FULL_NAME],InStr(1,[FULL_NAME],",")+1) & " " &
Mid([FULL_NAME],InStr(1,[FULL_NAME],",")+2,1) & "."

Thank you so much,

OMS
 
Back
Top