Maybe try the Switch function:

SELECT fldPart,
* * fldRev,
* * fldDescription,
* * Min(fldDueDate) AS cfldFirstDue,
* * Sum([fldQty])-Sum([fldQtyToBE]) AS cfldQtyToProcess,

SWITCH(fldReleaseType=0, "This is a 0", fldReleaseType=1, "This is a
1", fldReleaseType=2, "This is a 2")

FROM tblOrders
LEFT JOIN (tblOrderDetails
LEFT JOIN tblOrderReleases
* * ON tblOrderDetails.fldID = tblOrderReleases.fldDetail)
* * ON tblOrders.fldOrder = tblOrderDetails.fldOrder
WHERE (((tblOrders.fldStatus)=0)
AND ((tblOrderReleases.fldBEdComplete)=0))
GROUP BY tblOrderDetails.fldPart,
* * tblOrderDetails.fldRev,
* * tblOrderDetails.fldDescription;



Or just try the IIF(condition, true, false)

IIf(releasetypeid = 1, "Yippee", "foo!")

The true and false parts of the statement can be replaced with
calculated values

HTH