a bit of help

[wiredgecko]

hello everyone. this will be my first post.

i have date field 1 and date field 2 along with a field title "status".
what i am trying to accomplish is the following:

if date field 1 and date field 2 are blank then the status field should remain blank

if date field 1 is not blank and date field 2 is blank the the status field should read "waiting"

if both date fields are not blank then the status field should read "received"

Thxs

 

[Uncle Gizmo]

Where are these fields? Are they in a table or are they on a form?

 

[wiredgecko]

they are in a form

 

[gemma-the-husky]

 if nz(df1,0)=0 and nz(df2,0)=0 then
      "blank"
 else
      if nz(df1,0)>0 and nz(df2,0)>0 then
           "received"
      else
            "waiting"
      end if
 end if

note that there is an error condition of df1 being blank amd df2 being not blank

 

[George21]

Have you tried the After Update Event?