Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Aug 2002
    Posts
    247
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Access Rank question

    I have a simple question that I can't figure out but I'm sure someone who is an Access expert would know.

    I have reports that produce ranks for students based on their averages.
    In these reports I have Rank, Student Name, and average.
    I have reports for best to worst average and worst to best.

    When I run the reports the rank number goes from 1 to whatever. However, I hoping to have the rank number be the same if the average is the same.

    Example: the report shows this

    Rank Name Avg
    1 Smith 99.8
    2 Taylor 98.7
    3 Jones 98.7
    4 Charles 96.5

    How can I make the text box in the design view for rank show identical numbers if the averages are the same? So, the report would look like this:

    Rank Name Avg
    1 Smith 99.8
    2 Taylor 98.7
    2 Jones 98.7
    4 Charles 96.5

    Right now I have the control source for the text box set at "=1"

    Anyone that knows the solution - if there is one- if you could please enlighten me, it would be appreciated.

  • #2
    Regular Coder
    Join Date
    Apr 2005
    Location
    Look behind you...
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't know how to do it, but I suggest a Google Search Query. Go here if you want to see Google's results on the keywords 'MS Access Rank'.
    Web Tool Boy!
    - Domain information checker, dropping domains checker, + more.
    Domain Name Chat Forums - DNCForums.com
    - Get 50 points closer to a FREE domain name or a FREE rapidshare account!
    Live It My Way! - Lifestyle Forums
    - Enjoy your life, talk about interesting topics, get coupons!


  •  

    Posting Permissions

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