Finding records within a year range
I have two tables, one is 'Membership' data (includes a Membership_Year field) and another table named 'Year Range' with just two number fields Start_Year and End_Year.
I want a script to find records from the Membership table where the year of membership is between two dates (just the year) from the Year Range table.
For instance, members with a Membership_Year value of 2013 or 2014. Have tried with a table with preset values for the Start_Year and End_Year using global values and with normal values.