Access - The MID function

December 2016



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".

Related :

This document entitled « Access - The MID function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.