http://www.accessoft.com/blog/?user
Where ((([姓名] & [性别] & [家庭住址] & [手机] & [id] & [A区] & [B区] & [C区] & [年龄] & [漕河一路]) like IIf(IsNull(forms.frmCRMSearch.Txt_search),'*','*' & forms.frmCRMSearch.Txt_search & '*'))) and ((([姓名] & [性别] & [家庭住址] & [手机] & [id] & [A区] & [B区] & [C区] & [年龄] & [漕河一路]) like IIf(IsNull(forms.frmCRMSearch.Txt2),'*','*' & forms.frmCRMSearch.Txt2 & '*')));
把这个改为 精确查询 怎么改??
那位仁兄帮下忙,谢谢
ID=1669
精确查询其实没那么复杂,我开始也是和你一样被弄晕了。
看以下解决:
Where ((([姓名] & [性别] & [家庭住址] & [手机] & [id] & [A区] & [B区] & [C区] & [年龄] & [漕河一路])
IIf(IsNull(forms.frmCRMSearch.Txt_search),'0',forms.frmCRMSearch.Txt_search ))) and
((([姓名] & [性别] & [家庭住址] & [手机] & [id] & [A区] & [B区] & [C区] & [年龄] & [漕河一路])
IIf(IsNull(forms.frmCRMSearch.Txt2),'0',forms.frmCRMSearch.Txt2)));
思路:去掉LIKE,直接将需要查询的对象放进去就行了!!!