I have the following query
Full Name: [FNAME] & " " & [MNAME] & " " & [LNAME]+IIf(IsNull([DESIGN]),""," ," & [DESIGN])
I am getting the follwing:
John D. Doe ,PHD
I want to eliminate the space between Doe and the Comma.
It should read like = John D. Doe,PHD
Can please help me out. I tried every single thing and I cannot make to work.
Thanks
Jimmy
Full Name: [FNAME] & " " & [MNAME] & " " & [LNAME]+IIf(IsNull([DESIGN]),""," ," & [DESIGN])
I am getting the follwing:
John D. Doe ,PHD
I want to eliminate the space between Doe and the Comma.
It should read like = John D. Doe,PHD
Can please help me out. I tried every single thing and I cannot make to work.
Thanks
Jimmy