Query Database

Query Database

Select fields to be downloaded. Use the CTRL button to select more than one field
	Suppress duplicates Table header Edit records Limit rows Start Row

Sort order:
First Ascending Descending
Second Ascending Descending
Third Ascending Descending
Fourth Ascending Descending

Select search conditions (at least date):

Start Date

End Date

Initials (optional)

Species (optional)

Region/County (optional)

Location (optional)
% is wildcard

Breeding (optional)

County Records (optional)

Rare Regular
(optional)

Casual
(optional)

Accidental
(optional)

My County Birds
(optional)

>	Suppress duplicate county/species

Notes (not null)

Pending

Accepted

Ebird

Excluded

MNBBA Records

Selected Excluded Neither

Output Type:
Plain Table File Checklist
This tool is used to search the MOU sightings database. You can select any combination of fields to return, holding down the CTRL key to select multiple fields. Checking "suppress duplicates" results in duplicate results being suppressed. The sort order of the results is First (if selected), Second (if selected), Third (if selected), Forth (if selected), Date, Initials, and finally order of entry. Sort order is alphabetic, except species is taxonomic. Output types: Plain - fields separated by "\|", Table - fields in table format for easy reading, and File - a comma separated format that can be input to Microsoft Excel.

Output Type:

Plain Table File Checklist

This tool is used to search the MOU sightings database. You can select any combination of fields to return, holding down the CTRL key to select multiple fields. Checking "suppress duplicates" results in duplicate results being suppressed.

The sort order of the results is First (if selected), Second (if selected), Third (if selected), Forth (if selected), Date, Initials, and finally order of entry. Sort order is alphabetic, except species is taxonomic.

Output types: Plain - fields separated by "|", Table - fields in table format for easy reading, and File - a comma separated format that can be input to Microsoft Excel.