|
|
Hy! Can you please take a took at the following code and tell me what is wrong:
demand = "SELECT DISTINCTROW[CustomerInfo].[Customer] "
demand = demand + " FROM [CustomerInfo] LEFT JOIN Projects ON [CustomerInfo].CustomerID = Projects.ProjCustomerID "
demand = demand + " WHERE Projects.PrjLeader= " + ProjLeader.Value
demand = demand + " AND ([Projects].[Date]>= #" + FirstDate.Value + "#) AND "
demand = demand + " ([Projects].[Date]<= #" + SecondDate.Value + "#)"
What I am trying to do is obtain all the customers that have signed a contract between 2 dates (paragraph 4 and 5) and have worked with a specific project leader.
Please help
|
|
|
|
try to use something like this :-
BETWEEN Date1 AND Date2
|
|
|
|
|
|
|
|
|
|
fulicea84
Yusairi
