Filtering in Queries and Tables

From NeoWiki

You can filter the data you see when viewing tables or queries by using filters. This tutorial provides some examples, using the All Sightings query. The process is the same when working with tables.

Steps for Filtering

1. Open the All Sightings query. (in the main database document, click on Queries in the left hand column, then double click on All Sightings).
2. Click on the Filter button on the toolbar (it looks like a funnel).
3. Set the Field Name, Condition, and Value fields as needed for your filter. If using more than one criterion, you also need to set the Operator for the all but the first criteria.
4. Click OK
5. The table adjusts, showing only those records that meet the criteria.
6. To turn the filtering off, click on the highlighted green circle with the check mark (Apply Filter) or the red stop sign with an x on the toolbar (Remove filter.sort).

Filter Examples

Here are some examples of filters you can set with this query:

Goal	Operator	Field Name	Condition	Value
Birds seen at a Clamath Falls:		Field_Trip_Location	Like	Clamath Falls
Birds seen after 3/3/1900		Date	>	03/03/1900
Birds identified by Voice		Voice	=	'TRUE'
Birds identified by Voice but not by Sight		Voice	=	'TRUE'
	AND	Sight	<>	TRUE

Many other combinations are possible.