AnsweredAssumed Answered

Find Date Range

Question asked by RashinAlizadeh_1 on Jul 11, 2012
Latest reply on Jul 12, 2012 by philmodjunk


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.