Access - The MID function

April 2018


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".
Published by aakai1056. Latest update on November 25, 2011 at 12:09 PM by aakai1056.
This document, titled "Access - The MID function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Access - The RTRIM function
Access - Concatenate strings