In Access, the Right function extracts a substring from a string starting from the right-most character.

The syntax for the Right function is:

Right ( text, number_of_characters )