Victor - there are probably a couple of ways to approach getting this done but if it were up to me I'd have a additional two fields: A single character box in which I'd put an "X" if I intended to override the default amount and then a small text entry line to explain why the numbers don't match. Then the formula for the third field would read something like "if ["X" Box] is " " then Field 1 else "Field 3". Got it?
Don On Wed, Aug 7, 2013 at 12:29 PM, [email protected] <[email protected]> wrote: > Help with formula > > I am having a problem with constructing a formula to cover the following > situation: > > > 1. A field (Value 1) with format G-£ZZ,ZZZ,ZZ9.99. > 2. A field (Date) with format DDMY99-99-9999. > 3. A field (Value 2) with format G-£ZZ,ZZZ,ZZ9.99. > > > A value is always entered into the Value 1 field. > > The panel which contains these fields is changed when I receive a payment. > I do this by entering the date when the payment is received (into Date). > > Normally the payment received equals Value 1. I would like to have a > formula in Value 2 whereby > > 1. if a date is entered then I would like the amount entered for Value 1 > to be automatically entered into Value 2. > 2. But I wish to manually override the formula with an amount I enter into > the Value 2 field if the amount of the payment is different is different to > the amount in Value 1. > > I have no problem with constructing the formula for 1 but having > difficulty in allowing for 2. > > Would another DataPerfect be able to help? > > Victor Warner. > > ______________________________**_________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/**cgi-bin/mailman/listinfo/**dataperf<http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf> > -- *Don Friedman ProfessionalRecords.Com LLC PRS Data Systems Liveport WiFi* * * *205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax*
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
