Set rs = ado_query("select * from JFxfjl where HID=" & rqid & " and DATEDIFF('d',now(),sj)=0 and QK like 'IP为%'")
或者
Set rs = ado_query("select * from JFxfjl where HID=" & rqid & " and DATEDIFF('d',now(),sj)=0 and instr(QK,'IP为')=1")
推荐用第一种
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024