I have tried to use:
Left([First Name],InStr([First Name],",")-1)
to obtain only the first name from the field "First Name" without any middle name (or initial). I create a new field row in the design view of a table, and indicate it to be calculated.
Please offer the most efficient manner to do this.