Filtering to display most recent

[GarageFlower]

Right i have a table

which lists football players and what days they scored their goals. so its a total history for the season. so for example if tierry henry scores 32 goals he will have 32 different entries

how can i run a query which will tell me when each player scored their most recent goal and only display the most recent goal, so therefore each player will only have one row.

 

[Eckerslike]

If you create a query using this table, go to the view menu and click on totals. This will put an additional row called total in your query expression. Everything will be set to Group By, go to the column containing your date and select Max. This will return the latest goal scored for each player as long as there is nothing else that is unique per row.

 

[GarageFlower]

that is correct thank you

but as you said what if i want to see who passed the ball to him and sethim up as well before hand.

that will add in extra rows

is there anyway i can just view the most recent goal with all the information about it, ie, time, assist, competition etc