Split, Trim, Separate Names

[Superock]

Hi all,

I have a table with field Username, the format for the Username is Smith, John A.

Not all names have a middle name and some even have a Title. What I would like to do is split these names into separate fields.

FirstName, MiddleName, LastName, Title

I have used the Left and Mid function to seperate the last and first name but can not get the middle name out. Any help will be appreciated.

Left(EDSUserDump!UserName,(InStr(1,EDSUserDump!UserName,",")-1))

Mid(EDSUserDump!UserName,(InStr(EDSUserDump!UserName,",")+1))

Thx

Superock