need to rank in a query

Discussion in 'Microsoft Access Queries' started by pat67, Sep 2, 2010.

  1. pat67

    pat67 Guest

    Hi all here is my problem. I need to find the last vendor for a part
    that was bought. I have a table with all of the receipts. The problem
    is if i group by the part and vendor and look for the max delivery
    date, i get the last time the part was bought for each vendor it was
    bought from. i want the last vendor period. example


    part ABC was bought from vendor 1 on 8/23, vendor 2 on 8/12 and vendor
    3 on 7/25, when i run the query i get this

    Part Vendor MaxofDate
    ABC 1 8/23
    ABC 2 8/12
    ABC 3 7/25

    all i want to see is this

    Part Vendor MaxofDate
    ABC 1 8/23

    can someone explain how to do this for me?

    Thanks
     
    pat67, Sep 2, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Nelson

    How do I Rank each record in a query?

    Nelson, Aug 1, 2003, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    220
    Tom Ellison
    Aug 1, 2003
  2. Desert Moon
    Replies:
    4
    Views:
    579
    Desert Moon
    Oct 14, 2004
  3. Guest

    I need the rank of groups in the Field

    Guest, Jan 31, 2005, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    166
    Allen Browne
    Jan 31, 2005
  4. pat67

    need to rank in a query

    pat67, Sep 2, 2010, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    265
    pat67
    Sep 2, 2010
  5. pat67

    need to rank in a query

    pat67, Sep 2, 2010, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    596
    John Spencer
    Sep 3, 2010
Loading...

Share This Page