[这个贴子最后由懂你在 2009/01/14 02:38pm 第 7 次编辑]
如题:我设计了一个查询统计计算公式,但不知错在哪,请高手帮忙斧正,谢谢!
egd文件下载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([%参加工作时间%] > "" And [%计算时间%] > "",FilterFor("工龄", ">=" ,[%参加工作时间%],"工龄", "<=" ,[%计算时间%], True ) And If([%出生年月%] > "" And [%计算时间%] > "",FilterFor("年龄", ">=" ,[%出生年月%],"年龄 ", "<=" ,[%计算时间%], True )And SetVariable("%人数%",CountFor("人员编制信息","姓名"," <> ","",0,0,1))
-=-=-=- 以下内容由 懂你 在 2009年01月14日 08:54am 时添加 -=-=-=-很多朋友帮了忙,在此谢谢!但一直没有解决。只好在这里有偿征求这个公式。请和我联系。QQ:155231978 请标明应征。
egd文件下载