I am looking to update the following data using an upodate and a where statement as follows.


update mbrsgrp031009 set mbrsgrp031009.compare_suffix = "Jr"
where mid(mbrsgrp031009.last_name,len(mbrsgrp031009.last _name)-1, len(mbrsgrp031009.last_name)) = "Jr"



Access does not seem to like.

Is there an alternative way to do this?