求教关于是否的计算

Access leev　发表于：2013-12-23 11:20:08 　

复制

现在只能实现一个计算就是，三个都是“是”的情况下，只是计算最后那个选择的，夜间是多30%，返回是×2 我最后点的夜间，差旅费（上）只显示多30%的，返回那个没有加入计算，怎么实现？

Top

奇玉发表于：2013-12-23 11:41:48

if me.是否夜间="是" and me.是否返回="是" and me.是否住宿="是" then ......差旅费*(1.3+2)

注：不知道你原来窗体及子窗体名是什么，请做相应修改。

Top

Access leev 发表于：2013-12-23 11:46:40

若有一个否了能变回另一个计算值吗？

Top

奇玉发表于：2013-12-23 13:13:32

if me.是否住宿="否" then ......＝差旅费*0

elseif me.是否夜间="是" and me.是否返回="是" then ......＝差旅费*3.3

elseif me.是否夜间="是" and me.是否返回="否" then ......＝差旅费*1.3

elseif me.是否夜间="否" and me.是否返回="是" then ......＝差旅费*2

else ......＝差旅费*1

end If

不知道写的对不对，试试吧。

Top

Access leev 发表于：2013-12-23 15:31:50

   Function CL() As Integer
If Forms![报价]![FH] = "否" And Forms![报价]![YJ] = "否" And Forms![报价]![ZS] = "否" Then 差旅费总 = Val(差旅)
    If Forms![报价]![FH] = "是" And Forms![报价]![YJ] = "是" And Forms![报价]![ZS] = "是" Then 差旅费总 = Val(差旅) * (1.3 + 2 + ([差旅人数] * 50))

         If Forms![报价]![FH] = "是" And Forms![报价]![YJ] = "否" And Forms![报价]![ZS] = "否" Then 差旅费总 = Val(差旅) * (2)
              If Forms![报价]![FH] = "是" And Forms![报价]![YJ] = "否" And Forms![报价]![ZS] = "是" Then 差旅费总 = Val(差旅) * (2 + ([差旅人数] * 50))
                   If Forms![报价]![FH] = "是" And Forms![报价]![YJ] = "是" And Forms![报价]![ZS] = "否" Then 差旅费总 = Val(差旅) * (1.3 + 2)

                          If Forms![报价]![FH] = "否" And Forms![报价]![YJ] = "是" And Forms![报价]![ZS] = "是" Then 差旅费总 = Val(差旅) * (1.3 + ([差旅人数] * 50))
                                 If Forms![报价]![FH] = "否" And Forms![报价]![YJ] = "否" And Forms![报价]![ZS] = "是" Then 差旅费总 = Val(差旅) * ([差旅人数] * 50)

                                       If Forms![报价]![FH] = "否" And Forms![报价]![YJ] = "是" And Forms![报价]![ZS] = "否" Then 差旅费总 = Val(差旅) * (1.3)


     End Function

没有简便的写法吗？还有差旅费总 = Val(差旅) * (1.3 + ([差旅人数] * 50)) 这样写对吗？先*50再+1.3倍再*本身怎么结果不对呢？[差旅人数]是个窗体控件

Top

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

Access交流中心

求教关于是否的计算