Unless there are some rules to the naming convention, you're going to struggle to find something that fits every case.

Does every name have LastName comma space FirstName?
Does every name that has a middle name always follow the firstname with a space and then the name?
Does every name have only 2 or 3 (if middle) names? There are no 2 last names, or titles, Jr. Sr. or anything?

Hi Adam,

Does every name have LastName comma space FirstName?
YES

Does every name that has a middle name always follow the firstname with a space and then the name?
YES, like the sample

Does every name have only 2 or 3 (if middle) names? There are no 2 last names, or titles, Jr. Sr. or anything?
I haven't seen any, yet,  So far all are 2 or 3 names.

You will need 2 Queries for this.

The first Query will give you the Last Name and the First/Middle combination.
The second Query is used to break apart the First Name and the Middle Name/Initial.

Thanks, Kevin!!

I think I misunderstood how Trim worked, I'll give them a whirl, but they will work perfectly.  I'll learn how to give you proper kudos too.
Sincerely,
Bill

It may be easier to do this in Excel, then copy the results to Access.

If you rely on spaces as delimiters, you may be thrown off by people with double surnames (Andrew Lloyd Webber) or maiden names (Hillary Rodham Clinton).  Sometimes these are hyphenated, but sometimes not.

@Kevin Robertson, Thank you! An error came up on the FM column so I had to put the length calculation in separate columns.
but it did the trick!