ASP Search Issue: Search MS Access record (project) using ASP

[hotflash]

Hi All,

I am working on a search feature, let's say if you type in the network "Cisco", it will search and display all of the projects under Network "Cisco" for me even the project is already closed. The search works fine however; I want to extend the SELECT statement where it will ONLY display the project IF the Network=Cisco and CompleteDate="NULL" means there is nothing in the field (another word is the project still opened - blank field).

UserInput.html

<TR>
<TH ALIGN=LEFT> <FONT FACE="HELVETICA,HELV,ARIAL" SIZE=3>Project Search: </FONT></TH>
<TD><INPUT CLASS="bluebox" NAME="Network" TYPE="TYPE" SIZE="25" ID="Network"></TD>
</TR>

<TR>
<TD ALIGN="CENTER" COLSPAN=2> <INPUT CLASS="Table_Blue" TYPE="submit" NAME="Submit" VALUE="SEARCH PROJECT"></TD>
</TR>

DisplayProject.asp

Dim strNetwork
Dim strCompleteDate

strNetwork= trim(Request.Form("Network"))

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("PTSystem.mdb")

strSQL = "Select * FROM TableProjects WHERE Network='" & strNetwork & "' AND CompleteDate='""'"

RS.Open strSQL, Conn

Can someone please take a look at the statement above to see if you have any comments. Thanks in advance for your help.

[hotflash]

Please ignore. It works fine for me now. I have to use CompleteDate IS NULL.

Thanks.