还是查询的问题,本已为搞懂了,没想到又出现新问题了!
我要查询的是出生日期在一定范围,并且要加上部门限制,代码如下
SELECT zrqk
a=thisform.combo1.Value
b=thisform.combo2.value
c=thisform.combo3.Value
d=thisform.combo4.value
e=a+ '. '+right( '0 '+ALLTRIM(b),2)
f=c+ '. '+RIGHT( '0 '+ALLTRIM(d),2)
g=VAL(e)
h=VAL(f)
i=ALLTRIM(thisform.combo10.value )
IF i= "所有部门 "
search= "csrq> = "+ALLTRIM(STR(g,7,2))+ " and csrq <= "+ALLTRIM(STR(h,7,2))
ELSE
search= "csrq> = "+ALLTRIM(STR(g,7,2))+ " and csrq <= "+ALLTRIM(STR(h,7,2))+ " and ALLTRIM(zrqk.Dwmc)= "+i
endif
SET FILTER TO
SET FILTER TO &search
COUNT TO rs
thisform.text4.Value =rs
thisform.list1.Requery
thisform.refresh
现在当选择 "所有部门 "的时候,一切正常,但是当选择部门的时候,如 "机关 ",既i= "机关 ",执行查询会提示找不到 "机关 "这个变量,怎么回事呢,请指教 (dwmc既是单位名称的字段)
[解决办法]
search= "csrq> = "+ALLTRIM(STR(g,7,2))+ " and csrq <= "+ALLTRIM(STR(h,7,2))+ " and ALLTRIM(zrqk.Dwmc)= ' "+i+ " ' "
