Share this page:

MS Access: Right Function

Learn how to use the Access Right function with syntax and examples.

Description

The Microsoft Access Right function extracts a substring from a string starting from the right-most character.

Syntax

The syntax for the Microsoft Access Right function is:

Right ( text, number_of_characters )

Parameters or Arguments

Text is the string that you wish to extract from.

Number_of_characters indicates the number of characters that you wish to extract starting from the right-most character.

Applies To

The Right function can be used in the following versions of Microsoft Access:

  • Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

Example

Right ("Tech on the Net", 3)
Result: "Net"

Right ("Alphabet", 5)
Result: "habet"

Example (in VBA Code)

The Right function can be used in VBA code in Microsoft Access. For example:

Dim LResult As String

LResult = Right ("Alphabet",3)

The variable LResult would now contain the value of "bet".

Example (in SQL/Queries)

You can also use the Right function in a query in Microsoft Access.

Microsoft Access