Calculation method of cumulative balance in Access database

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 set up the table (assuming the save name is "financial balance"), the table must have a date, debit, credit, summary, and other fields, plus an AutoNumber field "ID." After design, input data.

Create a query. 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]].

Run this query to see the "Balance" field and the cumulative balance value you need.

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