Querry help with Dates

[jimhmason]

I have a database which records each time a member of my tennis club comes in to get their tennis racquet restrung. I record lots of data about the transaction, but the most important is the date they come in to get the racquet restrung. I would like to contact each person that did NOT have their racquet restrung within the past year. Since, I create a new record EACH time the person comes in to have it restrung, I am having difficulty writing a querry for this. For example a person could come in on Jan 15th and July 15th of 2011. However, when I run the querry, I should NOT be getting this person returned to me as NOT being strung for the past year until AFTER July 15th of 2011. I would be happy to email my database for a better expanation.....my email address is jimhmason@comcast.net

[pbaldy]

Base your query on one of these (you may just need the first):

http://www.baldyweb.com/LastValue.htm

which will get you the last date for each person.