Access App Coalesce will not populate on null value.
Posted on 2016-09-15
I have an access App that has a list of employee. I have a field set to combine First, Last, and Nickname, however if the employee does not have a nickname, the name does not show up at all on the datasheet.
This is my current formula:
Coalesce([First Name]+" "+[Nickname]+" "+[Last Name],[Email])
I cant figure out how to write the formula to accept the null value. thanks