Calculating Fields and Manual Input

Hello,
Is it possible to have a field that is both calculated or manually
inputted?. For example, if field 1 and field 2 has data then calculate field
3. Can we also have the user simply enter the total amount into 3. What I
have noticed is if I enter an amount directly into field 3 and field 1 and 2
do not have data the value goes back to 0 (which makes sense) but wondering
if there is a way around this.

Thanks!

Kris
Sun Jul 01 03:39:05 CDT 2007

On Jul 1, 6:06 am, MDV1457 <MDV1...@discussions.microsoft.com> wrote:
> Hello,
> Is it possible to have a field that is both calculated or manually
> inputted?. For example, if field 1 and field 2 has data then calculate field
> 3. Can we also have the user simply enter the total amount into 3. What I
> have noticed is if I enter an amount directly into field 3 and field 1 and 2
> do not have data the value goes back to 0 (which makes sense) but wondering
> if there is a way around this.
>
> Thanks!

This is a logic problem. What you need is something like,

if( field1.value != "" or field2.value != "")
{
field3 = ...
}

That will only change the value for field3 if both of the other fields
do not have blank values. If either one has blank values, field3 will
remain unchanged.