Find Date Range
I have a database with the history of the office's executive elections. The officers were elected for terms from 1 to 5 years. Therefore there is some sort of election (some smaller than others) every year.
I have a layout where the user can enter new election results as they happen which includes fields for First name, Last Name, , position, year of election, term duration (through which FM then automatically calculates the end of their term), and end of term.
I want the user to be able to search a certain year, say 1984, and see all the elected people holding a position in that year. This would include people who were elected in 1984 or those whose term began before 1984 but has not yet ended.