修改:
查询字符串用:
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE '%" & strQuery & "%'"
查询数字用:
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE %" & NumQuery & "%"
查询字符串用:
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE '%" & strQuery & "%'"
查询数字用:
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE %" & NumQuery & "%"
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE '%" & strQuery & "%'"
并且在asscess中,通配付支持"*"号
strsql = "SELECT * FROM tab1 WHERE fieldname LIKE '*" & strQuery & "*'"