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. > > ================================================ > > > > > >
