I am building a DB for several aircraft. I am collecting all sort of data some are populated with numerical information and some are populated with a yes, no, or n/a. I can easily do a query that can tell me how many totals occur using the numerical data. However, I am having a problem counting that data using the yes no or n/a answers. I am wondering does anyone now how do a query that can count all my yes, nos and n/as in one column but at the same time sum my numerical data in one.