A pre-existing table was created with lastname, firstname contained in one field. I would like to create a new table with a separate field for lname & fname. Is there a way to take the existing names and put them in separate fields? (Some contain a middle initial as well)

This is a fairly regular sort of question. Do a search.

If this gets you nowhere, come back and we'll help.

Thank you. I found what I needed.