I need to get the Initials from First and Last fields. Doesn't seem to much on the forum relating to this. I have something (attached) that was already in my database but this doesn't work.
if( not IsEmpty(First); Left (First;1) ) & if( not IsEmpty(Last); Left (Last;1)
Upper( Left (First;1) ) & Left (Last;1))
The reason that calc does not work is that it is set up as a Case ( ) function. The way that works is the FM runs down the list of queries (e.g. not IsEmpty (First), not IsEmpty (Last) … ) in order from top to bottom until it finds one that returns True, which it then applies as per the expression for that argument. Importantly, FM then ignores all remaining queries, so it will never deliver an answer to the second query if the first returns true.
Try the expressions suggested by Nicolai instead.
Keep in mind that names have a wide variation. Consider:
Mary Ellen Burns
Mary von Beethoven
Retrieving data ...