ValveResult: IIf(797 In (SELECT tblOptestTable.TestResultID FROM tblOpTestTable WHERE tblOpTestTable.WorkorderID = [WorkorderID]),"Failed","Passed")
This is a field in a query... i'm using grouping for the unique WorkorderID then i'm trying to get whether any one of the test results for this...