Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    172

    Unanswered: Using between operator

    Appleman
    Cisco
    Jones
    Greer
    Smith
    Thompson

    What is the most widely expected way for a user to enter a starting and ending range for a report?

    If I use the SQL statement, Between Appleman and Greer, the results would be:

    Appleman
    Cisco
    Jones

    Greer would not be included in the set.

    If I take the Gr from Greer and make the r an s (the next character) then Greer gets included in the search results.

    Maybe I'm making this too complicated. But you get the point.

    Using Access 2k3.

    TIA

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try between Aa and Rzz

  3. #3
    Join Date
    Sep 2004
    Posts
    161
    I tried this query and i have this result :
    SELECT Table1.Champ1
    FROM Table1
    WHERE (((Table1.Champ1) Between 'Appleman' And 'Greer'));

    Appleman
    Cisco
    Greer

    Where is your problem ?

  4. #4
    Join Date
    Dec 2003
    Posts
    172

    results

    Was away for several days. Just catching up. It turned out my test was flawed and thus gave me bad results. The search worked as it should have after all.

    Thank you both for the help.

    JoeG

Posting Permissions

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