0 Replies Latest reply on Jun 25, 2007 8:37 AM by clixmax

    List of record according to the date/time or id and frequency

    clixmax
      i have a few record such as like this:

      id module date semester student no.
      12 R2001 12/06/07 1 A1
      15 C1001 12/06/07 1 A1
      16 R2001 26/01/08 3 A1

      could somebody help me to produce the output like this:

      If the student (A1) wants to print the registration slip for semester 1, for the Module of R2001 will show the frequency of 1 for the 1st time.

      If the student (A1) wants to print the registration slip for semester 3, for the Module of R2001 will show the frequency of 2 because it was the second time he registered the same module.

      I'm really don't know how to make a query for this. please help me.