5 Replies Latest reply: Jun 13, 2011 4:34 PM by kevinprusa RSS

    Only show most recent of multiple entry

      Sorry for the poorly worded title but I'm not sure how to explain in one sentence.

       

      I have an enormous amount of package tracking data I'm trying to organize, and I have every update of the package tracking.

       

      Example:

       

      Package1 - 5/19 - 2:30 - picked up

      Package1 - 5/19 - 3:30 - in transit

      Package1 - 5/20 - 8:02 - departed

      Package1 - 5/20 - 9:45 - delivered

      Package2 - 5/19 - 2:30 - picked up

      Package2 - 5/19 - 3:30 - in transit

      Package2 - 5/20 - 8:02 - departed

      Package2 - 5/20 - 9:45 - delivered

      Package3 - 5/22 - 7:42 - picked up

      Package3 - 5/22 - 9:37 - in transit

       

      How do I get may table to only show the most recent update?

       

      Package1 - 5/20 - 9:45 - delivered

      Package2 - 5/20 - 9:45 - delivered

      Package3 - 5/22 - 9:37 - in transit

       

      I receive file every 2 hours and add this data to a qvd which I then make the table I am asking about.

       

      Thanks!