If txtClass <> "" Or txtYear <> "" Or (txtMon1 <> "" And txtMon2 <> "") Or (txtMaterialA <> "" And txtMaterialB <> "") Or txtJournalNumber <> "" Or txtGroupNumber <> "" Or txtProductNumber <> "" Or txtAcctNumber <> "" Then
sqlstr = sqlstr & " and REF_N01 like '%" & txtCust.Value & "%'"
Else
sqlstr = sqlstr & " where REF_N01 like '%" & txtCust.Value & "%'" End If
End If
为什么返回一个INPUT框
添加这个参数后表里是空的,不加这个参数输出正常,着急,谢谢
sqlstr = sqlstr & " and REF_N01 like '%" & txtCust.Value & "%'"
Else
sqlstr = sqlstr & " where REF_N01 like '%" & txtCust.Value & "%'" End If
End If
为什么返回一个INPUT框
添加这个参数后表里是空的,不加这个参数输出正常,着急,谢谢
程序是对的,我把no1写成n01找不到字段了
谢谢大家