League Table

[Mark Richardson]

I am trying to create a form that is based around a league table. When it opens i would like access to extract specific information from one of my tables and then display the records in a specific order. This order will depend on how many check boxes have been ticked. The form will be used to show the progress of specific bits of data through production process. Ideally i would like the data to appear with the most amount tick boxes at the top. Now i was thinking about setting up a count function or possibly using a dynamic array. However, my understanding of arrays is some what limited. So any help or information regarding setting up arrays etc would be most apprediated.

Mark