Your help is appreciated with a solution to the following situation.
We have about 6 fields.
datum_M, SBB_label, Rejectlabel, KAPnr, datum_TS, datum_VVB
What I would like to achieve is a calculated column with the following in a expression:
If [datum_M] is empty show "1. In Production"
If [KAPnr] empty but not [SBB_Label] show "2. Ready for KAP"
If [SBB_Label] & [KAPnr] or [Rejectlabel] not empty show "3. Ready for Trucking"
If [datum_TS] or [datum_VVB] not empty show "4. Transported"
So far I came to ( & it works) :
IIf(IsNull([datum_M]),"1. In Production",IIf(IsNull([SBB_Label]),"2. Ready For Kap",IIf(IsNull([datum_TS] And [datum_VVB]),"3. To Be Transported","4. Transported"))).
The goal is not yet achieved. That's where I need you guys, how would the expression for this look like?