User:DrewJensen/check register

From Apache OpenOffice Wiki
< User:DrewJensen
Revision as of 06:52, 29 August 2010 by DrewJensen (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Personal tools