Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unhappy Unanswered: criteria in query

    pls. help, when I set enter name as my criteria in the query it works but you have to enter the exact name..example you have to type the name alexander and not alex only..

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so what else do you expect - intellignece from computer software?

    unless you speify a wild card character ("*", or "%" if running in ANSI compatibility mode) when you specify criteria it will look for an excat match

    so to find "Alexander", "Alexadry" specify your criteria as "Alex*"

    have a look at the help system for wild card for further rules you can use to match against

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Of course it only works if you type in "alexander" exactly. If it didn't, how would you tell the computer to only allow the exact string "alexander".
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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