if 表达试有问题

杨乐　发表于：2018-06-28 18:11:14 　

If Me.Combo72 = "扶贫住院" Then bclx = "FYMX" Else If Me.Combo72 = "扶贫门诊" Then bclx = "FPMZJM" Else If Me.Combo72 = "扶贫慢病" Then bclx = "FPMBJM" Else If Me.Combo72 = "签约服务" Then bclx = "表1" Else If Me.Combo72 = "民政优抚" Then bclx = "YFBX"
CSRQ = Form_HZCX.Text40
jsrq = Form_HZCX.Text42
strSQL = " SELECT '扶贫住院汇总' AS 减免类型 , COUNT ( ZYZFY ) AS 减免人次 , Round ( Sum ( ZYZFY ) , 2 ) AS 总费用 , Round ( Sum ( XNHBCJE ) , 2 ) AS 医保补偿费用 , Round ( Sum ( QTBCJE ) , 2 ) " & _
" AS 其它补偿费用 , Round ( Sum ( BCJMFY ) , 2 ) AS 减免费用 , Round ( Sum ( GRZFJE ) , 2 ) AS 个人自付费用 " & _

" FROM " & bclx & " WHERE " & bclx & ".HSSJ > # " & CSRQ & " # And " & bclx & ".HSSJ < # " & jsrq & " # GROUP BY " & bclx & ".CZY "

不知道怎么回事，一直出错，查询“扶贫住院”的时候能查出数据，但是“CZY"显示不出来，查询后面的那几项时一直提示让输入ZYZFY\XNHBCJE等这些值

哪位大神帮忙看看

这个IF语句也不麻烦啊，用块IF也不行，一直提示else后面没IF，不知道怎么回事

Top

leoyoung 发表于：2018-06-28 21:01:44

1、建议用case

Select Case Me.Combo72

Case "扶贫住院"

bclx = "FYMX"

Case "扶贫门诊"

bclx = "FPMZJM"

...

End Select

2、分组要对应

" SELECT '扶贫住院汇总' AS 减免类型.... GROUP BY '扶贫住院汇总' AS 减免类型

Top

总记录：1篇页次：1/1 9 1 :

Access交流中心

if 表达试有问题