Skip to Content
0
Former Member
Jun 10, 2009 at 08:19 PM

Formula returns null result if missing data in one field!

25 Views

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