Difference between revisions of "User:DrewJensen/check register"
From Apache OpenOffice Wiki
DrewJensen (Talk | contribs) (→what) |
DrewJensen (Talk | contribs) m (→what) |
||
Line 1: | Line 1: | ||
A very simple check register database | A very simple check register database | ||
- SQL example, get a running total from the Register table | - SQL example, get a running total from the Register table | ||
− | <source lang=" | + | <source lang="mysql"> |
SELECT | SELECT | ||
"ID", | "ID", |
Latest revision as of 06:52, 29 August 2010
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 :)
0.1 - table, view showing a running balance, form only partly working