Thank you for your help, i pasted that in to a new query SQL, not sure what you mean by WHERE CLAUSE, but in design view, only widow had TRUE. I wanted both Widower and Widow to have TRUE, but when I put TRUE in the WIDOWER, then run the query, it is all blank.. Sorry I am do dumb!!!! Any...