1 Reply Latest reply on Jun 25, 2011 11:04 AM by $Nith$

    Sorting data in a table

    Mary-Anne.R Level 1

      If I have a table in a form that the user enters data in to, is there anyway that it can be sorted and yet keep all the info in the row together?

      Here's an example:

      In the table below the user needs to enter all the data fortnightly for payroll, as payroll requires employees to be entered in numerical order according to their employee number each time someone leaves they have to delete them then move everybody up a row, the rows also add up hours (the example shows hours paid in the form there are columns for sick leave etc also and they total at the end of each row....any ideas on how I can make this easier to use? (keeping in mine I'm a novice)

       

      Employee numberName                    Hours paid
      001J.Smith70
      002S.Black55
      003K.White60
      004D.Jones65