User:DrewJensen/check register

A very simple check register database - SQL example, get a running total from the Register table

SELECT 
	"ID", 
	"Number", 
	"Date", 
	"Withdrawl", 
	"Deposit", 
	( 	SELECT 
			SUM( "Deposit" ) - SUM( "Withdrawl" ) 
		FROM "Register" 
		WHERE "ID" <= "R"."ID" ) AS "Balance" 
FROM "Register" AS "R"

- Dataview example, note the hidden ID column (or not :)

File:CheckRegister.odb

0.1 - table, view showing a running balance, form only partly working