Creating a Table

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:

DateCheckTo/FromForAmountTypeCleared
03/08/2009 April O'Neil web page500.00 deposit yes
03/23/2009123Joe the plumberunclog sink-100.00 check yes
04/05/2009 Wells Fargorefund200.00 depositno
04/06/2009  Bank month -10.00 feeno
04/19/2009 Amy Jonestickets21.00depositno
5 transactions
INDEX, 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

Copyright © Zebra0.com
All rights reserved worldwide.

 
 

Creating a table