I have a database that tracks memberships over several years. I am trying to create a query that gives a list of expired memberships based on the expiration date entered in the database. Since the past memberships are not purged from the database, my queries keep pulling in names of individuals that have already paid for next year. For example, if the previous membership ran from 9/01/02 - 9/01/03 the membership shows as expired even though they paid for a new membership that runs from 9/08/03 - 9/08/04. Please help with an expression for my criteria that will force Access to filter out the oldest dates and just look at the latest dates for each record. Thank you so much for your help in this matter.