Marc, here's one way to do this. I did not create a db and test this code, but any errors should be easy to find.
Insert your base data, and have one other column for the RunningBalance. CREATE TEMP TABLE TmpRunningBalance + (RunBalID INTEGER NOT NULL PRIMARY KEY, + InvDate DATE, + InvNum, + CustID INTEGER, + Amount CURRENCY, + RunningBalance CURRENCY) AUTONUM RunBalID IN TmpRunningBalance USING 1 INSERT INTO TmpRunningBalance (CustID, InvDate, InvNum, Amount) + SELECT CustID, InvDate, InvNum, Amount FROM Invoices + ORDER BY CustID, InvDate, InvNum + WHERE .... CREATE TEMP VIEW TmpBalances (RunBalID, Balance) AS + SELECT t1.RunBalID, SUM(t2.Amount) + FROM TmpRunningBalance + WHERE t2.RunBalID <= t1.RunBalID + GROUP BY t1.RunBalID UPDATE TmpBalances + SET RunningBalance = t2.Balance + FROM TmpBunningBalance t1, TmpBalances t2 + WHERE t1.RunBalID = t2.RunBalID --- Marc <[EMAIL PROTECTED]> wrote: > Hi Bernie > > That part makes sense but how do you get the > formula to use the Balance from the line above, > then add the next lines charges - the payments. > > Marc > > > > Marc, > > If a value is changed, place a bit button on your form with caption "Save > > Changes", create an eep that does a saverow. Put a hint in, that says "If > > you made any changes, click here to update" > > Then refresh the form. > > Bernie Lis > > ----- Original Message ----- > > From: "Marc" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, September 01, 2004 8:47 AM > > Subject: [RBG7-L] - Form calculation > > > > > > > HI all > > > > > > Is it possible to have a forumla something like a spreadsheet > > > in a region. > > > > > > I want something like this > > > Charge payment Balance > > > $50 $0 $50 > > > $50 -$20 $80 > > > > > > and if you changed one of the payments or charges the balance > > > on that line would be re-calculated and all of the rows below > > > as well. > > > > > > I can figure out how to do one line but I can't figure out how to > > > include the Balance form the line above. > > > > > > Thanks > > > Marc > > > > > > --- RBG7-L > > > ================================================ > > > TO POST A MESSAGE TO ALL MEMBERS: > > > Send a plain text email to [EMAIL PROTECTED] > > > > > > (Don't use any of these words as your Subject: > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > ================================================ > > > TO SEE MESSAGE POSTING GUIDELINES: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message SUBJECT, put just one word: INTRO > > > ================================================ > > > TO UNSUBSCRIBE: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > ================================================ > > > TO SEARCH ARCHIVES: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message SUBJECT, put just one word: SEARCH-n > > > (where n is the number of days). In the message body, > > > place any > > > text to search for. > > > ================================================ > > > > > > > > > > > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
