>SELECT MOS_OLPHKEY > MOS_OLREFNO > Sum(IIf(MOS_STATUS=4,0,IIf(MOS_STATUS=3,IIf(MOS_QTY_REC>MOS_QTY,MOS_QTY,MOS_QTY_REC),MOS_QTY))) AS [Booked Qty] >FROM MOS >GROUP BY MOS_OLPHKEY, MOS_OLREFNO >>
> >SELECT MOS_OLPHKEY > MOS_OLREFNO, > CASE MOS_STATUS > WHEN 4 THEN 0 > WHEN 3 THEN > CASE WHEN MOS_QTY_REC > MOS_QTY THEN > MOS_QTY > ELSE > MOS_QTY_REC > END > ELSE > MOS_QTY > END as AS [Booked Qty] > FROM MOS > GROUP BY MOS_OLPHKEY, MOS_OLREFNO >IMHO you translated the code correctly, just probably need to add the name of the field as I did.