Help Me! I Need 2 Create A League Table!!!

[greenelephant]

Hi there here are two screenshots of my project i am doing. One is of a league table, the other is a results table.

http://www.angelfire.com/oz/rooney/pic2.JPG

--------------------------------

http://www.angelfire.com/oz/rooney/pic3.JPG

Ok ill try and explain wot i want to do.

I want to create a from for the league table where it will count how many times each team appears in the winning column in the results sheet. The team which appears the most will go first in the position column in the league table. the next most occuring team shall be placed under the cell which contains the top team. The next team under that etc...


does n e 1 know how to do this!!!

I WOULD B VERY GR8FUL AS I NEED TO DO THIS BY MONDAY!!!!!![

[Ecniv]

Well..

what do you have in your school/college project so far??

An sql statement would be a start, which calculated the counts and ordered them as you require... Then how are you displaying it? Datagrid, flexgrid, listbox?

Is it in VB? Access? Oracle???


Vince