MEMDB

Searching for Years: Examples

The following queries are valid in the "Year" field:

1781 1785 1790	Searches for the records whose field "Year" is equal to 1781, 1785, or 1790.
1781 - 1785	Searches for the records whose field "Year" is equal to 1781, 1782, 1783, 1784, or 1785.
< 1785	Searches for the records whose field "Year" is less than 1785.
<= 1785	Searches for the records whose field "Year" is less than or equal to 1785.
> 1785	Searches for the records whose field "Year" is greater than 1785.
>= 1785	Searches for the records whose field "Year" is greater than or equal to 1785.