Add criteria to a query using ‘NOT’ logical operator
From the Queries area of the main window, right click the query and click ‘Edit’.
In the Criterion row, add criteria that uses the ‘NOT’ logical operator, e.g. in Description field type “NOT=‘Home’”. This will return any data that has a description not equal to Home, i.e. Mobile
Also, select ascending from the ‘Sort’ row for the Group field to order the results
Press F5 to run the query, then F4 to close the preview.
Add criteria to a query using ‘AND’ logical operator
In the Criterion row, add criteria that uses the ‘AND’ logical operator, e.g. in Group field type “<7 AND <>2”.
This will return any data that has a value less than 7 and not equal to 2
Add criteria to a query using ‘OR’ logical operator
In the Criterion row, add criteria e.g. in the group field type =8. Then, in the ‘Or’ row below, add another criterion, e.g. < 5. This will return data for all group values that are equal to 8 or less than 5.
Use a wildcard in a query, * or %, ? or _
Selecting the wildcard asterisk * in the field column will return all the fields from the selected table.
To run a query that searches for all Last Names beginning with J, in Criterion for Last Name field, type “LIKE J%”.
The % is a wildcard that stands for 0, 1 or more characters
In this case you could also type “LIKE J*” for the same result
Press F5 to run the query.
To run a query that searches for all First Names beginning with the letter ‘Bo’ with one character after them, in Criterion for Last Name field, type “LIKE Bo?” (or ‘_’ instead of ‘?’)
‘?’ or ‘_’ is a wildcard that stands for 1 character only.
Press F5 to run the query.