²éѯaccessµÄÀÏÊÇÌáʾ²ÎÊý²»×ã

ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿
SQL code:
SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null

---

SQL code:

SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and isnull(NET)


°ÑÄãVBÖеÄÓï¾äÍêÕûµØÌù³öÀ´
¾ÍÊÇʹÓÃADO»òDAO·ÃÎʵÄÓï¾ä

---

SQL code:

SELECT * from wcj WHERE Pno = '3' And Trim(Conclusion) = 'ºÏ¸ñ' and [NET] is null

---

VB code:
If Me.Check2.Value = 1 Then
If Me.Option1(3).Value = True Then
strSQL = " SELECT * from wcj WHERE Pno = '" & Trim(Me.TextPno.Text) & "' And TRim(Conclusion) = 'ºÏ¸ñ' and [NET] is null "
Else
strSQL = " SELECT * from wcj WHERE Pno = '" & Me.TextPno.Text & "' and (NET) is null "
End If

Else
If Me.Option1(3).Value = True Then
strSQL = "SELECT * from wcj WHERE([testdate] BETWEEN '" &a