Trying set up worksheets for use in access.

Sheet A has a list of doctors and their practices, i.e., Name= Smith, John
I., Practice= Anytown Pediatrics

Sheet B has a list of patients and their admitting doctor, but in this case,
it's Smith, John I (no period).

Trying to get to a result of associating the admitted patients to
appropriate practices. I think the best is to parse the MD cell by the comma
safter the last name but thought I would ask here for advice and assistance.

Can anyone help me out?
Thanks!!!!