|
If Range("D3") <> "" Then str = "[总价]" & Range("D3")
If Range("H3") <> "" Then str = IIf(Len(str) > 0, str & "and", "") & " [联系人] = " & "'" & Range("H3").Text & "'"
If Range("e3") <> "" Then str = IIf(Len(str) > 0, str & " and", "") & " [税率] = " & Range("e3").Text
If Range("g3") <> "" Then str = IIf(Len(str) > 0, str & " and", "") & " [合同类别] = " & "'" & Range("g3").Text & "'"
If Range("b3") <> "" Then str = IIf(Len(str) > 0, str & " and", "") & " [编号] like '" & Range("b3").Text & "%'"
'就这么加进去。。。注意like是区分大小写的
|
|