Conditions change the records found when searching a database field. Selecting the right condition will narrow the information in the report or mail list.

**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

**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

**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 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.