September 2, 200124 yr This must be a very easy one but I just can't seem to figure it out. I only want the field to be calculated if it's empty, so if there is a result already it should not calculate again If (field1=field2;result 1;don't change current field value) Thankyou so much for helping me out
September 2, 200124 yr Change the IF function to a Case Function: Case(Field1=Field2,Result1) [ September 02, 2001: Message edited by: Steveinvegas ]
Create an account or sign in to comment