Ranking Values in .asp using Access

m150

New Member
fairly new to .asp and the boards, so please bear with me. I am trying to utilize an access DB which stores 24 unique records (baseball teams) with values for TeamName, TeamUID (unique ID), TotalHR, TotalRS, TotalWins and TotalLosses. I would like to use this table to display where a team ranks in each category. For example each team has their own page which is based on their TeamUID. I want to show where they rank (1st through 24th) in each category but cannot figure out how to do that in the page. Any suggestions?
 
Back
Top