2 Replies Latest reply on Aug 31, 2013 2:42 AM by RogerWatson

    Finding records within a year range



      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.