Sorry but still having problems I have tried what DCrake said but it seems to be ok.
On my SurveySub On the record sorce I have this which it should work
SELECT DISTINCTROW SurveyDetail.DetailID, SurveyDetail.SurveyID, IIf([NoteNo]=0 Or [NoteNo] Is Null,Null,[NoteNo]) AS [Note]...