Difference between revisions of "User:DrewJensen/check register"
From Apache OpenOffice Wiki
DrewJensen (Talk | contribs) (→init) |
DrewJensen (Talk | contribs) m (→what) |
||
(2 intermediate revisions by the same user not shown) | |||
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 | ||
+ | <source lang="mysql"> | ||
+ | SELECT | ||
+ | "ID", | ||
+ | "Number", | ||
+ | "Date", | ||
+ | "Withdrawl", | ||
+ | "Deposit", | ||
+ | ( SELECT | ||
+ | SUM( "Deposit" ) - SUM( "Withdrawl" ) | ||
+ | FROM "Register" | ||
+ | WHERE "ID" <= "R"."ID" ) AS "Balance" | ||
+ | FROM "Register" AS "R" | ||
+ | </source> | ||
+ | |||
+ | - Dataview example, note the hidden ID column (or not :) | ||
+ | |||
[[file:CheckRegister.odb]] | [[file:CheckRegister.odb]] | ||
Line 6: | Line 23: | ||
− | [[Category:Database]][[Category: | + | [[Category:Database]][[Category:Base_Example]] |
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