Hi Lynn,
The "<>" symbol is the numerical equivalent of "Not Like". It is used to search for everything except the exact value you put into the "value field". Think of it as the opposite of "=". For example, if I was searching for patients in my database that are outside my state (in my case, RI) I would use the following criteria"
Demographics - State - <> - RI
This will return all patients that are NOT in Rhode Island.
If you are searching for patients between an age range, you would have to do 2 separate lines. For example, for your search that you gave the example for, the criteria would look like:
Demographics - Age - > - 18
Demographics - Age - < - 25
As far as the wildcard goes, you can enter "%" as a wildcard, but usually you have to click the "Show all query results" option to get the field to show the proper data. Other tricks that do work for certain fields is using "<>" or "Not Like"and then leaving value blank. That will return any result where that field is not blank. For example:
Demographics - City - <>- *leave value blank*
This will return all results for any city, as long as the city field is not blank.
