I have a field (FullName) that reverses the order of a person’s name in another field (ReverseName).

Example: Smith, Sara becomes Sara Smith

This is what the calculation looks like now for the FullName field:

Right (ReverseName; Length (ReverseName) - Position (ReverseName; " "; Length (ReverseName);-1))

& " " &

Left (ReverseName; Position (ReverseName; " " ;1;1) - 2)

This works OK, but some people have two first names (Sara Gray Smith).

How can I write a calc for a Name field with two first names?

Example: Smith, Sara Gray should become Sara Gray Smith

TIA lpm

If your data is entered consistently use the comma to get your position. Everything to left of the comma is the last name & everything to the right is the first. This will be helpful if/when you get last names like Van Buren etc.