Top 4 Query

[carlton123]

Does this help

http://allenbrowne.com/ranking.html

Brian

thanks that's great it works, thank you everyone that helped also

 

[jdraw]

Glad you have it solved.
It might be helpful to others if you posted your solution-SQL.

Here's what I tried:

SELECT qryOwnwerRaceMinPosition.OWNER
	,race
	,qryOwnwerRaceMinPosition.minofposition
	,(
		SELECT count(OWNER) AS LowerCount
		FROM qryOwnwerRaceMinPosition AS XX
		WHERE xx.race = qryOwnwerRaceMinPosition.race
			AND xx.minofposition <= qryOwnwerRaceMinPosition.minofposition
		) AS OwnerRanking
FROM qryOwnwerRaceMinPosition;

where the first query qryOwnwerRaceMinPosition is

SELECT ownerracepos.OWNER
	,ownerracepos.race
	,Min(ownerracepos.position) AS MinOfposition
FROM ownerracepos
GROUP BY ownerracepos.OWNER
	,ownerracepos.race
ORDER BY race
	,Min(ownerracepos.position);

Final result based on your test data in post 19

owner race minofposition OwnerRanking
RJC 1 1 1
GWA 1 3 2
TGR 1 5 3
TGR 2 1 1
GWA 2 2 2
RJC 2 4 3

Good luck.