James E Harvey wrote: > 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. > > <snip>
> 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. > > Why not just have a form level method that will update the balance column in the cursor every time a cell changes. Just start at the top add in deposits and subtract disbursements, then return to the original record. Peter _______________________________________________ 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.
