I have a colum in Access looks like this
Angervil, Moliere (PS, APS) 1
Arocha, Fernando (PS, Contractor, EDF) 2
I need to trim the Name colum that only have the last 3 letters. In this case, are APS and EDF. Sometimes there are two ","s and sometimes just one.
How can I do this?
Thanks for your help.