update query that copies a name

[alinapotter]

I need help: I have 3 fields: complete name, first name, and last name. I need to create an update query that takes first name out of complete name field and copies it to the first name field and the same for the last name field. Names in complete name field formated as Last name, First name. Example: Johnson, Steve


Thank you

[alinapotter]

I figured out this function for the first name field: Left([CompleteName],InStr(1,[CompleteName],",")-1)
Still need help with the last name field.

[JoeM]

This should do it:
FirstName: Mid([CompleteName],InStr(1,[CompleteName],",")+2,Len([CompleteName]))

Note: it doesn't matter so much the length of the string your return, as long as it is at least long enough, and you are starting in the correct spot.

[alinapotter]

Ok...Right(Trim([CompleteName]),Len(Trim([CompleteName]))-InStr(1,[CompleteName],","))

[alinapotter]

Thank you, that worked as well.