Left and Instr function

[mohsin via AccessMonster.com]

Hi

Need your help please:
My field have:
mohsin
mohsin,ismail

I'm using this code to get mohsin from left :
CGR1: IIf(Left([tbl_route]![CGR_NAME],InStr([tbl_route]![CGR_NAME],",")-1),
[tbl_route]![CGR_NAME])

the result is #ERROR and mohsin,ismail

can you advise me, what is the right code, please.

thank you.

 

[Ken Snell \(MVP\)]

Try this:

CGR1:
IIf(InStr(([tbl_route]![CGR_NAME],",")>0,Left([tbl_route]![CGR_NAME],InStr([tbl_route]![CGR_NAME],",")-1),[tbl_route]![CGR_NAME])

 

[mohsin via AccessMonster.com]

Thank very much indeed ken, is work....

Try this:

CGR1:
IIf(InStr(([tbl_route]![CGR_NAME],",")>0,Left([tbl_route]![CGR_NAME],InStr([tbl_route]![CGR_NAME],",")-1),[tbl_route]![CGR_NAME])

Hi

[quoted text clipped - 13 lines]

thank you.