出纳问题

aslxt

怎么这个世道真的变了啊，求助怎么还要回复才能看到细节啊！！！！！！！！！！！！

aslxt

查询方式：控件来源=【=nz(DSum("收入","表1","编号<=" & [编号]),0)-nz(DSum("支出","表1","编号<=" & [编号]),0)】
也可用收入、支出的更新后事件为余额控件赋值（表中要增加”余额“字段），

Private Sub 收入_AfterUpdate()
  Me.余额 = Nz(DSum("收入", "表1", "编号<=" & [编号]), 0) - Nz(DSum("支出", "表1", "编号<=" & [编号]), 0)
End Sub
Private Sub 支出_AfterUpdate()
  Me.余额 = Nz(DSum("收入", "表1", "编号<=" & [编号]), 0) - Nz(DSum("支出", "表1", "编号<=" & [编号]), 0)
End Sub