Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003(2000 format)

    I want to be able to find records with a # sign in an Address2 field.

    Entries in the field are like
    RR 7
    R.R. #22
    RR #4

    Seems as if Access treats numbers as if being the same as the # sign. Because when I put criteria in the Address2 field in a query I get, for example, all 3 rows as above.

    I want to be able to find only the 2 that include the # sign.

    I have tried...
    Like "*#*"
    Like "*" & Chr(35) & "*"

    Both yield the same result.

    Is there a way?

    Tom

  2. #2
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Actually, the following works...
    Like "*[#]*"

    Tom

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Yes it does - in fact that will work for any of the special characters you want to find or filter on.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •