selecting range of records
I have a database of magazine writers, with a field with the history of their articles. It looks like this:
Review history: 05/02, 07/10 letter, 08/04
(that means the February 2005 issue, a letter in the October 2007 issue, the April 2008)
I want to be able to select records from a certain period (like all the contributors for 2007 ofr from 2006 to 2008). Is there a way I can do that?
Alternatively, how should I have set this database up to make this kind of thing possible in the future? There are about 1700 records, and some of them have as many as 10 entries in this history field.