7,759
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM wcj WHERE Pno = '3' And TRim(Conclusion) = '合格' and (NET) is null
SELECT * FROM [wcj] WHERE [Pno] = '3' And TRim([Conclusion]) = '合格' and [NET] is null
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 '" & MaskEdBox1(0).Text & "' AND '" & MaskEdBox1(1) & "') and Trim(conclusion) = '合格' "
Else
strSQL = "SELECT * FROM wcj WHERE([testdate] BETWEEN '" & MaskEdBox1(0).Text & "' AND '" & MaskEdBox1(1) & "') "
End If
End If
If TxtScancode.Text <> "" Then strSQL = "SELECT * FROM ResultData WHERE(([ScanCode] ='" & TxtScancode.Text & "') and ((NET) is null))"
Set rst = DB.OpenRecordset(strSQL, dbOpenDynaset)
SELECT * FROM wcj WHERE Pno = '3' And Trim(Conclusion) = '合格' and [NET] is null
SELECT * FROM wcj WHERE Pno = '3' And TRim(Conclusion) = '合格' and isnull(NET)