I created a formula field called fullname, with this formula:
TrimRight({Employee.Last_Name}) & ", " & trimright({Employee.First_Name}) & " " & {Employee.Middle_Name}
If the employee has a middle name, the result in fullname is as expected. If the employee middle name is empty, the formula returns a null result. What's going on?
Help!!
Thanks,
William