I currently have a query that is suppose to show only the Top-10 players for a specific position based on the criteria I set for the Rank column on the Design View.
This specific column is titled "Top 10," yet currently I go ahead and rank all players for their position. However, since I have 15 players being ranked, the query is showing all 15 players, yet I would love for it to show just the top ten players. What do I need to type in for the criteria to get it to show just the top 10 and not every player that gets a rank?
When typing in the criteria, there are enough rows for me to type in 1, 2, 3, 4, 5, 6, 7, 8, and, 9. But there isn't enough rows in the criteria for me to type 10. I have also tried typing all in one row, but it doesn't accept it. I've typed it in as "1,2,3,4,5,6,7,8,9,10" and not it wasn't allowed.
Any help again would be great. Hopefully I am following the forum rules.
Last edited by yes sir; 08-23-2010 at 01:27 AM.
I figured it out.
By going to design view of my specific query. Under the Design Tab, Query Setup, there was an option for the query to return a specific amount of records. I set it to 10, and it is showing my Top 10 even though I have more than 10 players ranked.
Good job Yes Sir, you are a genius.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks