4 Replies Latest reply: Dec 10, 2012 6:42 AM by Mark Shoubridge RSS

    Finding a list of last records

      Hello everyone,


      I have a question. How can I find the newest record for a list of contacts? I have the following data



      and so on...


      CustA has brought 500 items over the last 6 years

      CustB has brought 300 items over the last 6 years

      CustC has brought 800 items over the last 6 years

      and so on...


      The fields are

      Customer, Transaction Date, Transaction Year, Item.


      What I would like to find out is a list of the last transaction a customer has made so that I can see they are a current customer or a customer which used to buy from us but no longer does.


      Thank you in advance for any help possible