Duplicate values (Access 2000 & XP)

[troedel]

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.

[Alexya1]

Hi Trena... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Do a Totals query so that you can group the records by member... and then use the Max() function on the start date...
This should give you the results you're looking for...

Post back with field and table/query names involved if you need more specific help...

[troedel]

Trudi,

Thank you! I will give that a try and see what happens.

Trena