Rank / Position

[shark70]

Hi

I am trying to set up a football predictor database but am having problems with the Position column in the League Tables.

I have the Points, Goal Difference, Goals For etc., OK but I don't know how to show the Position column as the 2nd table below shows by Points then Goal Difference

Can anyone help please?

Team Points Goal Diff Goals For Goals Against
Arsenal 12 11 16 5
Chelsea 12 5 6 1
Bolton 9 3 7 4
Tottenham 8 2 4 2
Middlesbro 7 1 9 8

Position Team Points Goal Diff Goals For Goals Against
1 Arsenal 12 11 16 5
2 Chelsea 12 5 6 1
3 Bolton 9 3 7 4
4 Tottenham 8 2 4 2
5 Middlesbro 7 1 9 8

Thanks
Shark70

 

[Uncle Gizmo]

Make a query based on your table and put descending as the sort order for each field in turn:

Team Points (Desc) Goal Diff (Desc) Goals For (Desc) Goals Against (Desc)

Desc = Descending

 

[shark70]

Hi

I probably didn't explain that properly (I'm new to this)

I already have the query which sorts the Points, GD etc., but I need to add a Position column and I don't know how to do that

Thanks
James

 

[Uncle Gizmo]

I think you explained it very well, the problem is that I don't read very well! I'm always getting the wrong end of the stick.


Have a look here at Roger Carlston's site

 

[shark70]

Thanks for that - I think it should work

James