多查询条件问题
strSQL = "Select * from ky WHERE 状态= " "开业 " " and 区域= ' " & Combo1 & " ' "
For ii = 0 To Me.List1.ListCount - 1
If List1.Selected(ii) = True Then strSQL = strSQL & " or 拟定店名= ' " & List1.List(ii) & " ' "
Next
以上查询条件为什么当list1.listcount 超过100条记录时,就查询不了?请问这个代码应怎么写才对?
另外,如果我再加一个查询条件,记录也是在100条以上的呢?如销售货品的[货号]?
[解决办法]
strSQL = "Select * from ky WHERE 状态= " "开业 " " and 区域= ' " & Combo1 & " ' "
For ii = 0 To Me.List1.ListCount - 1
response.write Me.List1.ListCount - 1 --你打印一下，看看结果！
Next
