I just created a database in Access from my Quickbooks customer list. The first field contains both first and last names. I want to seperate the names into another field. Some of the records have First name first others have last name first seperated by a comm... Login to read more.