Need help creating Access 2003 Query criteria
Posted on 2012-08-30
I am trying to figure out how to create a query that will only show results that meets a specific criteria. I have attached a screen shot to show you the fields I am working with. I need a query that will ONLY show records that first fall into a date range and secondly contain one or more fields that are checked mark as yes. If non of the yes/no fields are checked as yes, then the record should not be displayed in the query results. There are 10 YES/NO fields in each record. Even if only one of them are checked yes, then the records needs to be included BUT if non are checked yes, then the record should not be included.
Does anyone know of a way to do this?