Error code for my Queries and Forms for abbreviating initials

[bbv586]

I have a pretty specific question to see if anyone sees an error in the code from my database. I'm getting the error code below when I click on my "Open Jobs" button on my database. I believe the problem is somewhere in my code for the line in the second screenshot - SalesPerson2: Left([SalesPerson],1) & Left(Right(Trim([SalesPerson]),Len(Trim([SalesPerson]))-InStr(1,[SalesPerson]," ")),1)



The purpose of that line is to abbreviate SalesPerson's name to their initials. Any help is appreciated.

[Gicu]

Try to replace Left(Right(Trim([SalesPerson]),Len(Trim([SalesPerson]))-InStr(1,[SalesPerson]," ")),1) with:
Mid(Trim([SalesPerson]),InStr(Trim([SalesPerson])," "),1)
Cheers,
Vlad

[Micron]

The general scuttlebut is that this is a missing Reference issue.

The purpose of that line is to abbreviate SalesPerson's name to their initials.

Seems like a very convoluted way to get JS from Joe Smith...

[davegri]

Good practice table design is to separate the last name and first name into different fields. If so, getting initials is trivial.