还是查询的有关问题,本已为搞懂了,没想到又出现新有关问题了

还是查询的问题,本已为搞懂了,没想到又出现新问题了!
我要查询的是出生日期在一定范围,并且要加上部门限制,代码如下
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+ " ' "