I have a table that is basically a ledger for a bank account. I have a query that adds in a column for balance, & computes the balance as a running total. Here is the Field:
RunningBal: Format(DSum("[tblEmergency_Ac ct].[Amount_ER]","tblEmergency _Acct","[Transaction_ID_ ER]<= " & tblEmergency_Ac ct.Transaction_ ID_ER),"Currenc y")
It works fine.
I have a form for users to input new ledger entries. I want to display the ending balance on that form - I believe I have to use a sub-form for that, & do a requery each time an update happens.
I created a form, put in just the balance field from the query; however, when I go to the view for it - it shows the initial balance at the top rather than the ending balance from the last record. How do I get the ending balance to display (and then update)?
RunningBal: Format(DSum("[tblEmergency_Ac ct].[Amount_ER]","tblEmergency _Acct","[Transaction_ID_ ER]<= " & tblEmergency_Ac ct.Transaction_ ID_ER),"Currenc y")
It works fine.
I have a form for users to input new ledger entries. I want to display the ending balance on that form - I believe I have to use a sub-form for that, & do a requery each time an update happens.
I created a form, put in just the balance field from the query; however, when I go to the view for it - it shows the initial balance at the top rather than the ending balance from the last record. How do I get the ending balance to display (and then update)?