Micron,
I did what you said in post 4, even adding the Is not Null to the <>"" makes no difference. I will get duplicates headers if there is more than one comment.
Code:
SELECT CheckList.EX, CheckList.ThreadNum, CheckList.ThreadDef, CheckList.ThreadStep, CheckList.ThreadStepDesc, DCount("*","[CheckList]","[ThreadNum]='" & [ThreadNum] & "'")+0 AS StepTTL, CheckList.VALEXPri, CheckList.ThreadStepNum, qryPassPercent.PerD, IIf([Pass]=True,DCount("Pass","Checklist","[ThreadNum]='" & [Threadnum] & "'"))+0 AS PrPass, CheckList.Capability, CheckList.Concept, CheckList.Demo, CheckList.Complete, CheckList.VALPRIThread, CheckList.InVALEX, CheckList.Comments, IIf(IsNull([Comments]) Or [Comments]="",Null,[ThreadStep]) AS TStep, CheckList.ID, CheckList.DateCOMPDone, CheckList.Pass, CheckList.Fail
FROM CheckList LEFT JOIN qryPassPercent ON CheckList.ThreadNum = qryPassPercent.TNum
WHERE (((CheckList.Comments)<>"" And (CheckList.Comments) Is Not Null)) OR (((CheckList.ThreadStepNum)=1))
ORDER BY CheckList.EX, CheckList.VALEXPri, CheckList.ThreadStepNum;
Thanks
Wayne