Right function and left function are not working in Access 2000. Is anyone else having this problem and if so is there a cure?