Thanks for your replies. !
DCrake, I was hoping that since the second element is separated from the third by two spaces rather than by a single one there might be a way to convince Access to recognize the distinction between the second element and the third even though sometimes the second...
I have a table that stores information about documents. Three of the fields in the table are Author, Recipient and Title fields. Some of the data in this table was imported from an Excel spreadsheet which didn't have Author or Recipient fields. Instead, the spreadsheet creator put the Author and...