Access update Query to separate full name

From: Judy K (K_at_discussions.microsoft.com)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 13:47:01 -0800

I am trying to separate a NAME field which has the last name followed by a
comma followed by the first name. Could you give me the function (s) that I
need to place the Last name in a field called Lname and the first name in a
field called Fname?

Thank you