Access - The MID function

December 2016


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


MID( text, position, num_of_characters )

    • 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/


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

Related :

This document entitled « Access - The MID function » from CCM ( 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.