在循环与取舍中折腾字符,可在同一字段中多内容查询。望老师给予斧正。(这里引用了 钱玉炜老师的 [示例] 求特定字符出现在字符串中的次数。在此致谢)
czf = LTrim(czf) ' 把字符串头部的空格去掉
kgs = CSNumber(Me.czf, " ") '字符中空符的个数
'Do While I = kgs '
For I = 1 To kgs + 1 '根据空字符的个数循环
If I = 1 Then zf3 = LTrim(czf) ' 把字符串头部的空格去掉
For ii = 1 To Len(zf3)
If Mid(zf3, ii, 1) = " " Then
zf2 = LTrim(Mid(zf3, 1, ii - 1))
strWhere = strWhere & "([题名] Like '*" & zf2 & "*') or "
zf1 = Right(zf3, Len(zf3) - ii) ' Mid(zf3, ii, Len(zf3))
Exit For
End If
Next ii
zf3 = LTrim(zf1)
zf4 = zf4 + Left(zf3, ii - 1)
Next I
zf2 = LTrim(zf2) + zf3
strWhere = strWhere & "([题名] Like '*" & zf3 & "*') and "
If kgs = 0 Then strWhere = "([题名] Like '*" & czf & "*') and "
End If
点击下载此附件