Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate values (Access 2000 & XP)

    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.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate values (Access 2000 & XP)

    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...

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate values (Access 2000 & XP)

    Trudi,

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

    Trena

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •