ranking a query or report

I have a report that ranks plyers based on the winning percentage. I
just have a running sum so it adds 1 to each name. The problem is this
does not work when I use the report as a sub-report to show the teams
and players. What I am looking for is this. A report that shows each
team and their record as well as the players on that tteam and their
record. and what those players rank in the entire league. I currently
have everything but the last part. What happens is when the original
report shows as the sub-report, I only get the rank on the team. so
each team has players ranked 1 through 8. I am unable to figure out
how to do it on the query. Any suggestions would be helpful.

Thanks

Create a separate query with player ID just to rank in the league. Join on
player ID in your current query so that the player rank in league will
display in the subreport.

--
Build a little, test a little.


"pat67" wrote:

I have a report that ranks plyers based on the winning percentage. I
just have a running sum so it adds 1 to each name. The problem is this
does not work when I use the report as a sub-report to show the teams
and players. What I am looking for is this. A report that shows each
team and their record as well as the players on that tteam and their
record. and what those players rank in the entire league. I currently
have everything but the last part. What happens is when the original
report shows as the sub-report, I only get the rank on the team. so
each team has players ranked 1 through 8. I am unable to figure out
how to do it on the query. Any suggestions would be helpful.

Thanks
.