Access 2007 calculates the cumulative balance through a query

When accounting staff use manual bookkeeping, there will be a balance after "borrow" and "loan", which is the accumulated balance, that is, after each account is recorded. If you use computer bookkeeping, you can complete the calculation of the accumulated balance by querying.

First, the establishment of the table (assuming the save name is "financial balance"), the table in addition to the date, borrow, credit, summary and other fields, but also add an AutoNumber field "ID." After design, input data.

Second, the establishment of inquiries. Add the necessary fields to the query. Then write an expression in a blank field--Balance: NZ ("borrow", "financial balance", "[Date]<#" & [Date] & "#")) +dsum ("Borrow", "financial balance", "[Date]=#" & [Date] & "# and [id]<=" & [ID])-nz (DSum ("credit", "Financial balance", "[Date]<#" & [Date] & "#")-dsum ("credit", "Financial Accounting"), [Date]=# & [Date] & # and [id]<= & [ID]].

Three, run this query, you can see the "Balance" field and its cumulative balance value.

Description: This query is only suitable for raw table data. If you want to filter in a query, the remaining balance may be problematic.