SQL Multiple Query

Results 1 to 2 of 2

Thread: SQL Multiple Query

  1. #1
    Join Date
    Dec 1969

    Default SQL Multiple Query

    I want to query a database for records from a specific range of dates and either the name of a client or the name of an employee...I just can&#039;t figure it out. This is what I have so far, but it obviously doesn&#039;t work:<BR>SELECT * FROM Trip WHERE Day BETWEEN (#" & Begin_date & " # AND #" & End_date & "#) AND EmployeeID=EmployeeID ORDER BY " & strOrder & ";"<BR>Any suggestions?<BR>P.S. The EmployeeID=EmployeeID is trying to establish that the records of EmployeeID should equal the value from my form with a name of EmployeeID (a radio button).<BR>

  2. #2
    Join Date
    Dec 1969

    Default CROSSPOST! Answered


Posting Permissions

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