Hi everyone,
I have a field name RefNo, RevNo check the picture below:
what I want is display "LT" if Latest and "SS" if obsolete.
This is the formula that Im trying to get the result I want
Latest: IIf(Max([RevNo]=0),"LT",IIf(Max([RevNo]>1),"LT","SS"))
Sorry for the explanation. Thank you in advance
I have a field name RefNo, RevNo check the picture below:
what I want is display "LT" if Latest and "SS" if obsolete.
This is the formula that Im trying to get the result I want
Latest: IIf(Max([RevNo]=0),"LT",IIf(Max([RevNo]>1),"LT","SS"))
Sorry for the explanation. Thank you in advance