I have a Name field in an Access table with different formats. Sometimes the name is formatted like Smith, John and sometimes it is John Smith. I am trying to pull the last name into a separate field. I created this to pull for the format with the comma, but how can I add an additional way to pull the last name when there is no comma?
LName: Left([FullName],InStr(1,[FullName],",")-1)