Sql Statement

[jamesnkk]

Hi,

Can anyone tell me what wrong with the statement, when I run the program,
no record was selected.

Please Advise -

rs.Open "SELECT Process.Failure Code, Process.SN, Process.TestDat e From Process WHERE not isnull(failureC ode) AND TESTDATE>=" & CDate(StartDate ) & " And TESTDATE<=" & CDate(EndDate) & " ORDER BY Process.Failure Code, Process.SN,Proc ess.TestDate", conn

[puppydogbuddy]

Try this:

Dim strSql As String

strSql  = "SELECT Process.FailureCode, Process.SN, Process.TestDate "
strSql = strSql & " From Process" 
strSql = strSql & " WHERE Not IsNull(failureCode) AND TESTDATE >=" 
strSql = strSql & "#" & StartDate & "#" & " And TESTDATE <= #" & EndDate & "#"
strSql = strSql & " ORDER BY Process.FailureCode, Process.SN,Process.TestDate;"

rs.Open strSql, conn

[jamesnkk]

Try this:

Dim strSql As String

strSql  = "SELECT Process.FailureCode, Process.SN, Process.TestDate "
strSql = strSql & " From Process" 
strSql = strSql & " WHERE Not IsNull(failureCode) AND TESTDATE >=" 
strSql = strSql & "#" & StartDate & "#" & " And TESTDATE <= #" & EndDate & "#"
strSql = strSql & " ORDER BY Process.FailureCode, Process.SN,Process.TestDate;"

rs.Open strSql, conn

Wow!, it work !!!, thank you so much