Once we know that we can retrieve all of the transaction between two dates, we will modify the code to create a table from the rows that are retrieved such as the one below:
| Date | Check | To/From | For | Amount | Type | Cleared | |
|---|---|---|---|---|---|---|---|
| 03/08/2009 | April O'Neil | web page | 500.00 | deposit | yes | ||
| 03/23/2009 | 123 | Joe the plumber | unclog sink | -100.00 | check | yes | |
| 04/05/2009 | Wells Fargo | refund | 200.00 | deposit | no | ||
| 04/06/2009 | Bank | month | -10.00 | fee | no | ||
| 04/19/2009 | Amy Jones | tickets | 21.00 | deposit | no |
, Problem Statement, Useful function for forms with dates, The Form for new Transactions, A Few Little Problems, Which Checks have Cleared: ALTER TABLE, Optional Arguments, Creating a table, Download the Checking Project
Next lesson: FilesMAIN INDEX
EXAMPLES INDEX