Access - Search for names containing specific characters

July 2016




Issue


My application must show all names containing the following two letters IS. What criteria should I put in the Name field?

Answer

  • Use "* IS *".
  • Access will search for names containing characters between the 2 stars symbol.

See also :

This document entitled « Access - Search for names containing specific characters » 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.