Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find a literal character (2002)

    How do I create a Query Criteria to find a hash sign (#) within a text field? I.e. how can I tell Access to look for a literal character? Thanks, Andy.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Find a literal character (2002)

    <P ID="edit" class=small>(Edited by Jezza on 28-Feb-06 13:41. Missed asterik in the original post)</P>Have you tried:

    Like "*[#]*"
    Jerry

Posting Permissions

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