Hi,
I have a football database with a table for league_standings.
I have structured this table as a list so that I update the league position after each new game played.
The columns are TEAM, GAMES_PLAYED, POSITION.
So for instance each team will have numerous rows in this table, one for each game they have played and their current position in the league.
I want to build a query from this table to show the current league position.
So I want to show the rows for each team where there entry in the 'GAMES_PLAYED' column is at its highest.
Currently each team has entries for GAMES_PLAYED as 1 and 2 as there have only been 2 games played in the Premier League so far this season by any one team.
How do I display the current league position of each team from this table?
Do I need to use dmax function? I did try this but it returned an error?
Thanks
Rob.