Flag a value in a group...
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
|