Query Database

Query Database
Some of this information has not been reviewed and should be treated as preliminary.

Select fields to be downloaded. Use the CTRL button to select more than one field
	Suppress duplicates

Table header :
Include selected fields
Editing :
Edit records

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

Select search conditions (at least date):

Start Date

End Date

Observer (optional)

Species (optional)

Region (optional)

Block (optional)

County (optional)

Breeding (optional)

County Records (optional)

Casual (optional)

Accidental (optional)

Notes (not null)

Output Type:
Plain Table File Checklist
This tool is used to search the MNBBA 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, Observer, 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, File - a comma separated format that can be input to Microsoft Excel, and Checklist - a Minnesota checklist of species reported.

Output Type:

Plain Table File Checklist

This tool is used to search the MNBBA 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, Observer, 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, File - a comma separated format that can be input to Microsoft Excel, and Checklist - a Minnesota checklist of species reported.