Access - The MID function

Ask a question


Description


This function allows you to retrive a section of a string.

Syntax


MID( text, position, num_of_characters )


Where:
    • Text : is the string of characters
    • Position : the point from which it will extract characters
    • Number of characters: the number of characters that will be returned by the function/

Implementation


MID(ccm,3,2) will return "os".

Access - The RTRIM function
Access - Concatenate strings