Results 1 to 3 of 3
  1. #1
    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

    Like memo field (2K3)

    The answer to this little problem seems to be hovering in my head but I can't think why.

    A friend has just rung me up stating taht he has a memo field in which he has text like "Bar Code 12345678 added by Fred" He wants to do a search the field for the bar code reference and do something. I suggested that in query he just does like "*12345678*" to get the record but this does not find it. I am at a loss as to why it can't find it. I have a mad idea that as he works for an American company the Access version may have different wildcards but i think I maybe clutching at straws...any ideas?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Like memo field (2K3)

    Wildcards are the same in any version of Access, but if he has turned on SQL Server compatible syntax (ANSI-92) in the Tables/Queries tab of Tools | Options..., he should use
    <code>
    ALike "%12345678%"
    </code>
    If the table is a linked SQL Server table, the same may hold.

  3. #3
    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: Like memo field (2K3)

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

    I had everything apart from ALike...thank you
    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
  •