Multiple conditions in Access

[engr_saud1]

Hi ,
I am trying to calculate [current status] based on multiple conditions. for example
Current status = A , if (w>0 and x=0 and y=0 and z=0)

Current Status =B , if(w>0 and x>0 , y=0 and z=0)
Current Status =C , if(w>0 and x>0 and y>0 , z=0)

Current status =D , if(w>0 and x>0 and y>0 and z>0)


Where A,B,C,D are text values and w,x,y,z are dates


Thanks!

[JoeM]

There are a few different ways of doing it. You could use a nested IIF function in an Access calculated field.
Or, if you have a lot of conditions, I often find it easier to create a User Defined Function (UDF) in VBA, using nested IF functions or Case statements.

I have a question though. If w,x,y,z are really dates, will they ever really be equal to 0? Or do you have NULL values instead?