Query criteria

Query criteria are composed of operators and values.  Gopher uses 'AND' and ‘OR’ logic for all queries.  Advanced queries can be performed with MS Access, MS Excel and by viewing and changing the query syntax in a ‘find’ list (refer to Query syntax for more information).‘AND’ logic means that all the values must be present in a record for it to be selected by the query.  ‘OR’ logic means that at least one of the values must be present in a record for it to be selected by the query.

More:

Query Operators