Results 1 to 30 of 30

Thread: **RESOLVED**SQL Assistance PLEASE!

Threaded View

  1. May 19th, 2003, 11:59 AM #1
    Salvatore
    Salvatore is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Location
    New York
    Posts
    679

    **RESOLVED**SQL Assistance PLEASE!

    The SQL statement below is what I currently have that is working:

    VB Code:
    1. rs.Open "SELECT RepName FROM Main WHERE RepName = '" & txtRepName.Text & "'"
    I need to ammend this statement with another condition...I also need to query by date that is between #5/1/03# and #5/31/03#.

    Something like:

    VB Code:
    1. rs.Open "SELECT RepName FROM Main WHERE DateRef BETWEEN #5/1/03# AND #5/31/03#"
    My problem is , how do I combine both conditions into one statement?

    Thank you.
    Last edited by Salvatore; May 20th, 2003 at 10:22 AM.
    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