I would like to make an sql request (With an access databse) witch contain two compare operators. For example, i want the request to return only the records wtich contain the correct CustomerID AND the correct DateOrder. Following is the code i tried, but it doesn't work. Could anyone say me if it is possible to code it, and how do it ?
Dim MyDb as Database, ResultRequest as Recordset, CustID as Long
Set MyDb = OpenDatabase (MyDatabase)
Set ResultRequest = MyDb.OpenRecordset ( "Select * From [Order] " & "Where [OrderDate] = #" & Calendar1.value & "#" & "AND" & " [CustomerID] = #" & CustID & "#")
Where CustID come from another request of another table.
The system display me an error when trying to execute this code.
I hope someone know the correct answer.
Thank you in advance