Results 1 to 3 of 3
  1. 01-17-2013, 12:56 PM #1
    bishop0071
    bishop0071 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    24

    Create a rank in report

    I have a report that has 2 fields. Name (concatenate of FirstName and LastName) and Total Points. I want a number rank system for it.

    Example:
    1st Name #1
    2nd Name #2
    3rd Name #3
    3rd Name #4
    5th Name #5 (since there is a tie for 3rd it goes to 5th rank)
    6th Name #6
    6th Name #7


    6th Name #8
    9th Name #9
    etc.

    Any help is appreciated.
    Reply With Quote Reply With Quote
  2. 01-17-2013, 03:34 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,623
    Review
    http://allenbrowne.com/ranking.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 01-17-2013, 03:47 PM #3
    ssanfu
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Google "ranking in access reports". Lots of hits....
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Provide Ranking & Select on the basis of Rank
    By dolovenature in forum Programming
    Replies: 3
    Last Post: 09-11-2012, 04:46 AM
  2. How to Use Rank function in MSACCESS
    By kiranmahale in forum Access
    Replies: 3
    Last Post: 12-06-2011, 11:19 PM
  3. please need help RANK
    By Andyjones in forum Queries
    Replies: 8
    Last Post: 09-10-2011, 12:12 AM
  4. Rank Function
    By Dongola in forum Programming
    Replies: 1
    Last Post: 05-07-2011, 06:05 PM
  5. Seeking to pruduce rank by year
    By JLR in forum Queries
    Replies: 0
    Last Post: 01-21-2008, 06:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums