How to unstring

I have a column in an Access database that contains "last name, first name". I'd like to copy that to a new column that contains "first name last name". Can anyone help?

Try this, copy and past it into the query "SQL view" and adjust it to your table and field names

UPDATE Table3 SET Table3.NewName = Mid([Table3]![Name],InStr(1,[Table3]![Name]," ")+1) & " " & Left([Table3]![Name],InStr(1,[Table3]![Name]," ")-2);