I have a table which I want to update a date depending on which condition I choose from Field1. Field1 uses a text lookup list (Trigger1, Trigger2 etc..) Field2 is astart date(date type). Field3 (DateType) is where i want to display my End Date result. I used the expression builder in criteria for field 3IIF([Field1]="trigger1",Field2+11,[Field1]="Trigger2",Field2+15)) but get an error message. essentially what I am trying to do is display a result in field 3 that add 11 days onto the start date if "trigger1" is used and 15 days if "triggger2" is selected. Any help gratefully received.