Hello I am working on a new project database. This time I need to compile a list of authors from a excel file I have imported into a new database.
I have all the data I need in my table, however I have run into small issue. I only want the main author to be queried from the author field on my table. See the picture for an example. It is the last author in the field. I am not sure how to do this without manually removing the other names from the field. I have 3000 of these to change. Is there a way to have Access do this for me?
See edit...
I have all the data I need in my table, however I have run into small issue. I only want the main author to be queried from the author field on my table. See the picture for an example. It is the last author in the field. I am not sure how to do this without manually removing the other names from the field. I have 3000 of these to change. Is there a way to have Access do this for me?
See edit...
Attachments
Last edited: