To run an Advanced Search within Redtail, click Search under your Contacts menu:
You'll then see an area where you can set up the parameters for your Advanced Search:
The Field menu presents you with a list of all of the fields within Redtail that you can set up a search for here. In this post, we'll take a look at the Age field:
After selecting "Age" from the Field menu, your next selection to make is the Operand you want to use with it. Your available Operands are:
- Begins With
- Equal To
- Greater Than
- Less Than
- Not Equal To
- Is Empty (NULL)
We'll show examples of the types of results you might expect from some of these, along with what you might enter in the Criteria box to get at your desired results.
Begins With — this is not a valid Operand with the Age Field.
Like — this is not a useful Operand with the Age Field.
Equal To — Use this when you want to pull up records with a specific Age:
This search would then display all contacts within your database who are currently 70 years of age.
Greater Than / Less Than —Use these when you want to pull up all contacts greater than or less than a specific age:
The above search would return all contacts in your database who are older than 64. The below search would return all contacts in your database who are younger than 80:
Note: you could run a two-level search with both of these Operands at the same time to find all contacts between two ages. If you wanted to find all contacts older than 64 but younger than 80 with one search, you'd set that up as in the below example:
Not Equal To — if you need to find everyone in your database that is not equal to a certain age, you can use this operand:
This would return all contact records whose Age is not 65.
Is Empty (NULL) — this operand will return all contacts in your database for whom no Date of Birth has been entered: