MS Access - Query for Number Sign


Apparently to query for number signs inside text fields in Access, you need to surround the # with square brackets, e.g. [#]. 



http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1421272

tags: msaccess, hash, symbol, number, sign, query, syntax
Related Scribbles:
  • Microsoft Access Links
    		•
  • SQL Date Syntax in MS Access, SQL
    		•

    ID: 909
    Author:
    leonard
    Date Updated:
    2008-07-02 17:04:56
    Date Created:
    2008-07-02 17:04:56

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> MS Access - Query for Number Sign
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.