![Criteria Conditions](https://manual.theatremanager.com/processed_images/b1b64070b111fe3600.png)
Criteria Conditions
![Criteria Conditions](https://manual.theatremanager.com/processed_images/d3179b49cd2f8b8b00.png)
Conditions change the records found when searching a database field. Selecting the right condition will narrow the information in the report or mail list.
![Character Field Conditions](https://manual.theatremanager.com/processed_images/6022437b5a50b56300.png)
Character Field Conditions
![alt="Character](https://manual.theatremanager.com/processed_images/6022437b5a50b56300.png)
- is between: The parameters for the field are between to sets of factors.
- is greater than or equal to: The parameters for the field are greater than or equal to these factors.
- is greater than: The parameters for the field are greater than this factor.
- is less than or equal to: The parameters for the field are less than or equal to these factors.
- is less than: The parameters for the field are less than this factor.
- does not equal: The parameters for the field are not equal to this factor.
- is equal to: The parameters for the field are equal to this factor.
- contains: The text of the parameter is contained anywhere within the field.
- does not contain: The text of the parameter is not found anywhere within the field.
- begins with: The text of the parameter is found at the beginning of the field.
- ends with: The text of the parameter is found at the end of the field.
- is one of: The parameters for the field is one of this factor.
- is none of: The parameters for the field is none of this factor. Remember that the NOT operator paired with this condition will create a double negative.
- is empty: The field is empty - containing no characters at all
- is not empty: The field is not empty - meaning it contains anything
![Date Field Conditions](https://manual.theatremanager.com/processed_images/18374b6722ea42a700.png)
Date Field Conditions
![alt="Date](https://manual.theatremanager.com/processed_images/18374b6722ea42a700.png)
- is between: The parameters for the field are between two sets of factors.
- is greater than or equal to: The parameters for the field are greater than or equal to these factors.
- is greater than: The parameters for the field are greater than this factor.
- is less than or equal to: The parameters for the field are less than or equal to these factors.
- is less than: The parameters for the field are less than this factor.
- is empty: The parameters for the field is empty of all characters
- is not empty: The parameters for the field are not empty of one or more characters.
- year one of: The parameters for the field include the year being one of this factor.
- month one of: The parameters for the field include the month being one of this factor.
- day of month one of: The parameters for the field include the day of the month being one of this factor.
- weekday one of: The parameters for the field include the day of the week being one of this factor.
- day of year one of: The parameters for the field include the day of the year being one of this factor.
- is in last: This condition means that the the date is in the last xx days/weeks/months/years from the current date. You could use this to find:
- donations in the last week
- events in the past month
- volunteers in the past 90 days
- emails in the past 2 days
- etc.
- is in next: This condition means that the the date is in the next xx days/weeks/months/years from the current date. You could use this to find items that are coming up, such as:
- report on events in the next month
- letters due to be printed in the next week
- volunteer activities scheduled in the next 2 weeks
- passes or gift certificates about to expire in the next 7 weeks
![List Field Conditions](https://manual.theatremanager.com/processed_images/13ee495fe789f1cb00.png)
List Field Conditions
![alt="List](https://manual.theatremanager.com/processed_images/13ee495fe789f1cb00.png)
- is one of: The parameters for the field is one of this factor.
- is none of: The parameters for the field is none of this factor. Remember that the NOT operator paired with this condition will create a double negative.
![Numeric Field Conditions](https://manual.theatremanager.com/processed_images/8bdc2c662cda1ad300.png)
Numeric Field Conditions
![alt="Numeric](https://manual.theatremanager.com/processed_images/8bdc2c662cda1ad300.png)
- is between: The parameters for the field are between two sets of factors.
- is greater than or equal to: The parameters for the field are greater than or equal to these factors.
- is greater than: The parameters for the field are greater than this factor.
- is less than or equal to: The parameters for the field are less than or equal to these factors.
- is less than: The parameters for the field are less than this factor.
- does not equal: The parameters for the field are not equal to this factor.
- is equal to: The parameters for the field are equal to this factor.
- is one of: The parameters for the field is one of this factor.
- is none of: The parameters for the field is none of this factor. Remember that the NOT operator paired with this condition will create a double negative.