Hi all,
Is there a way to remove the " & " if the sFirstName is null in a trim function?
ProperName: Trim([FirstName] & " & " & [sFirstName] & " " & [LastName])
Thank you
Dave
Trim Funnction question
Expert
Windows 10 
Access 2016
Hi all,
Is there a way to remove the " & " if the sFirstName is null in a trim function?
ProperName: Trim([FirstName] & " & " & [sFirstName] & " " & [LastName])
Thank you
Dave
Last edited by d9pierce1; 10-23-2021 at 10:49 AM. Reason: mispelled
Very Inert Person
Windows 10 Access 2016
This is vba code or query? Could use IIF function to not add & if [firstname] is null.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Expert
Windows 10 Access 2016
IIF will work, thanks
Dave
Trim!
Trim value
Trim Function
Posting Permissions
Reply With Quote