Hi,
I am trying to build the function below into MS Access but I am having trouble writing it.
These are the what the columns reference.
D=Allotment H=Stop Sale Flag F=Remaining Allotment
=IF(AND(D2=0,H2="Y"),"Stop Sale",IF(AND(F2>=0,H2="Y"),"Cut-off",IF(AND(F2>0,H2<>"Y"),"Available",IF(AND(F2=0,H2<>"y"),"Sold Out"))))
Inv Status: IIf(([Stop Sale Flag]="Y") And ([Allotment]=0),"Stop Sale",IIf(([Stop Sale Flag]="Y") And ([Remaining Allotment]>0),"Cut-off",IIf(([Stop Sale Flag]<>"Y") And ([Remaining Allotment]>0),"Available",IIf(([Stop Sale Flag]<>"Y") And ([Remaining Allotment]=0),"Sold Out",0))))
Thank you,
Brett
Bookmarks