Hi I have a query where i have created a view and i want to extract every personid number where either there is a zero value shown or (I assume) its a null or blank The following is an example where I would like to get the personid that matches the criteria of either having nothing there or a zero. So I would like to select 1770, 3090, 15 and 21 PersonID FatherID MotherID 2146 2149 2148 169 2157 2158 1770 2168 0 3090 3789 0 15 21 I have tried to see if they are blanks and I am getting nowhere Help please Many thanks Adrian Mullins