codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  SQL query from VB to Access Database  fulicea84 at 10:53 on Thursday, September 15, 2005
 

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

  Re: SQL query from VB to Access Database  Yusairi at 02:56 on Thursday, September 22, 2005
 

try to use something like this :-

BETWEEN Date1 AND Date2

Yusairi: site expert
http://www.codetoad.com









CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums








Recent Forum Threads
• C++
• Re: refresh parent after closing pop up window
• Dynamic Insertion
• Date and Time function around the world???
• Significant Factors
• Perl array access
• Re: huffman encoding and decoding in C++...
• Perl One Liner: Replace {(
• Re: html including php, accessing the functions


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2009