If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Flag a value in a group...
Hi all, tia for any insight.
I have the following query that gives some totals for qty's in a releases table, pulling and grouping information (part number, rev and desc) from a details table. Table heirarchy is (one to manys) tblOrders - tblOrderDetails - tblOrderReleases SELECT tblOrderDetails.fldPart, tblOrderDetails.fldRev, tblOrderDetails.fldDescription, Min(tblOrderReleases.fldDueDate) AS cfldFirstDue, Sum([tblOrderReleases].[fldQty])-Sum([tblOrderReleases].[fldQtyToBE]) AS cfldQtyToProcess 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; There is one more piece of information I am trying to discern from this query, but am not sure how, or if, it is done. There is a field in tblOrderDetails called fldReleaseType with possible values of 0, 1 or 2. Is there any way, to somehow note in the returned set of records, if any of the records within a particular group has this fldReleaseType with a value of 1? I would be happy to just somehow know that one or more of the grouped records contains that value... it's not imperitive that I know which particular record has it. Can I create a calculated flag field that is True if a 1 is found? Many thanks, -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) |
Thread Tools | |
Display Modes | |
|
|