SELECT Product.IdProduct, Product.ProductName, Sum(OperationRow.Remain), Last(OperationRow.RetailPrice), 
FROM Product INNER JOIN (OperationType INNER JOIN (OperationList INNER JOIN OperationRow ON OperationList.IdOperationList = OperationRow.IdOperationList) ON OperationType.IdOperationType = OperationList.IdOperationType) ON Product.IdProduct = OperationRow.IdProduct
WHERE (((OperationType.IdOperationTypeLevelThree)=15
GROUP BY Product.IdProduct, Product.ProductName
ORDER BY IIf(Sum(OperationRow.Remain)=0,-1,1) DESC, Product.ProductName;

ORDER BY IIF (Func1 = 0, (IIf(Sum(OperationRow.Remain)=0,-1,1) DESC, Product.ProductName), Product.ProductName)

ORDER BY CASE Func1 WHEN 0 THEN (IIf(Sum(OperationRow.Remain)=0,-1,1) DESC, Product.ProductName)  
         ELSE Product.ProductName END;

IIF (Func1 = 0, (IIf(Sum(OperationRow.Remain)=0,-1,1) DESC, Product.ProductName), Product.ProductName)