Results 1 to 10 of 10

Thread: SQL "Between" (RESOLVED)

Threaded View

  1. Feb 3rd, 2004, 06:44 PM #1
    epixelman
    epixelman is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2003
    Posts
    1,005

    SQL "Between" (RESOLVED)

    What is wrong with this?

    VB Code:
    1. SearchData.Open "SELECT Book,Chapter,Verse,Scripture From Bible " & _

    2.                 "Where Book ='" & Combo1.List(Combo1.ListIndex) & "' BETWEEN '" & Combo2.List(Combo2.ListIndex) & "' " & _

    3.                 "AND Scripture LIKE '%" & Text1.Text & "%'", cnn

    I return no records using the BETWEEN.

    I know the rest already works because I tested it. When I added BEWTEEN it returns zero records.

    I NEED HELP FAST... deadline
    Last edited by epixelman; Feb 3rd, 2004 at 08:22 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width