We want to create a grid that "simulates" the look of an Excel file that has a column that is a "running" total of two other columns.
I can't make this work in a grid using the table itself, so I'm trying to create a cursor to use as the data source of the grid. Table structure is: Pk_cash auto increment primary key Date_serv date Comp_id c 3 Dep_dis n 11 2 Type_entry c 3 Sample data: 1 02/01/2007 SHS 1,000.00 DEP 2 02/01/2007 SHS 500.00 DIS 3 02/02/2007 SHS 2,000.00 DEP 4 02/03/2007 SHS 200.00 DIS Results desired in the grid: Date Deposits Disbursements Balance 02/01/2007 1,000.00 1,000.00 02/01/2007 500.00 500.00 02/02/2007 2,000.00 2,500.00 02/03/2007 200.00 2,300.00 The grid is read only, data will be added, edited in typical form with text boxes. The select below is missing the "running balance" column, and nothing I've tried has worked. SELECT cb.pk_cash, cb.date_serv, SUM(IIF(cb.type_entry="DEP",cb.dep_dis,0000000.00)) as deposit, SUM(IIF(cb.type_entry="DIS",cb.dep_dis,0000000.00)) as disburse FROM cashbal cb WHERE cb.COMP_ID = 'SHS' GROUP BY cb.pk_cash, cb.date_serv ORDER BY cb.date_serv James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: [EMAIL PROTECTED] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
