Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: First Record in a group

    I am trying to identify the first part part of a ticket.

    I have a group by Ticket Number. Within the ticket number there are a number of parts, each has a number, not neccessarily starting at 1.

    I need to identify which is the first number in that group. Once this is done I want to use this in a formula to say what is the departure date.

    Example:

    Seg Dep Date
    4 25/09/06
    5 01/10/06
    6 07/10/06



    The date I want to include and report on is the 25/09/06.

    HelpMePlease!

  2. #2
    Join Date
    Aug 2006
    Posts
    12
    Are you looking to always capture the "oldest" date for each ticket? Or are you trying to look for the smallest "Seg" value? Or, neither?

Posting Permissions

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