DGWhittaker
asked on
Access 2013 - Query Question - String Formatting
Greetings!
I have this in one of my queries, and I need to have it return the value in Proper Case.
FirstNameBase: IIf(InStr([Record Disposition]![Customer],Ch r$(32))>0, Mid([Recor d Disposition]![Customer],1, InStr([Rec ord Disposition]![Customer],Ch r$(32))-1) ,[Record Disposition]![Customer])
Thanks!
Dennis
I have this in one of my queries, and I need to have it return the value in Proper Case.
FirstNameBase: IIf(InStr([Record Disposition]![Customer],Ch
Thanks!
Dennis
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oops, nevermind, I had some noise in there where I copied from my original formula.
All is good in the lands!
Thanks Craig!
Dennis
All is good in the lands!
Thanks Craig!
Dennis
ASKER
Perfect!
Thanks!
Dennis
Thanks!
Dennis
ASKER
Okay, I tried that, but with this approach it gives me an invalid syntax error:
FirstName:StrConv(FirstNam
Thougths!
Thanks!
Dennis