ShowAllRows() Andif([%性别%] <> "",FilterFor("性别"," = ",[%性别%]) And LocateFor("性别"," = ",[%性别%]), True )And if([%机构名称%] <> "",FilterFor("机构名称", " = ",[%机构名称%]) And LocateFor("机构名称", " = ",[%机构名称%]), True )And if([%二级机构_主管单位%] <> "",FilterFor("二级机构_主管单位", " = ",[%二级机构_主管单位%]) And LocateFor("二级机构_主管单位", " = ",[%二级机构_主管单位%]), True )And if([%二级机构_机构名称%] <> "",FilterFor("二级机构_机构名称", " = ",[%二级机构_机构名称%]) And LocateFor("二级机构_机构名称", " = ",[%二级机构_机构名称%]), True )And if([%编制类别%] <> "",FilterFor("编制类别", " = ",[%编制类别%]) And LocateFor("编制类别", " = ",[%编制类别%]), True ) And if([%经费形式%] <> "",FilterFor("经费形式", " = ",[%经费形式%]) And LocateFor("经费形式", " = ",[%经费形式%]), True )And if([%个人身份%] <> "",FilterFor("个人身份", " = ",[%个人身份%]) And LocateFor("个人身份", " = ",[%个人身份%]), True )And if([%学历%] <> "",FilterFor("学历", " = ",[%学历%]) And LocateFor("学历", " = ",[%学历%]), True )And if([%进编渠道%] <> "",FilterFor("进编渠道", " = ",[%进编渠道%]) And LocateFor("进编渠道", " = ",[%进编渠道%]), True ) And if([%职务类别%] <> "",FilterFor("职务类别", " = ",[%职务类别%]) And LocateFor("职务类别", " = ",[%职务类别%]), True ) And if([%教师类别%] <> "",FilterFor("教师类别", " = ",[%教师类别%]) And LocateFor("教师类别", " = ",[%教师类别%]), True ) And If(text([%参加工作时间%]) > "" And text([%计算时间%]) > "",FilterFor("工龄", "<=" ,Year([%计算时间%])-Year([%参加工作时间%])), True ) And If(text([%出生年月%]) > "" And text([%计算时间%]) > "",FilterFor("年龄", "<=" ,Year([%计算时间%])-Year([%出生年月%])), True ) And SetVariable("%人数%",CountFor("人员编制信息","姓名"," <> ","",0,0,1))
注意：
1、CountFor("人员编制信息","姓名"," <> ","",0,0,1)用变量代替
2、从1楼开始就没看见有工龄列，自己加吧
加好友 
发短信
Post By：2009/1/13 14:37:00 [显示全部帖子]
Post By：2009/1/14 9:13:00 [显示全部帖子]
Post By：2009/1/14 9:41:00 [显示全部帖子]
Post By：2009/1/14 10:22:00 [显示全部帖子]
Post By：2009/1/14 10:55:00 [显示全部帖子]
Post By：2009/1/14 11:52:00 [显示全部帖子]
Post By：2009/1/14 13:49:00 [显示全部帖子]
