Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    12

    Unanswered: Please help with ranking - database uploaded

    Hi

    I have two tables one called players that has a list of players and match data which contains the following information.

    Team name Played Home Won Home Score1 Score2 points PLayed Away Won Away Score 3 Score 4 Points.

    I have a query that calculates the total to show the following.

    Player Name Total PLayed Total Won Total Lost Total For Total Against Total Points.

    Within this query I want to add a pos: field so that I can rank them in order 1st 2nd third etc even though the report I have based on the query already sorts them highest to lowest.

    can anyone help with this an expression like dcount or an example i could download.

    I am also willing to email copy of database for you to look at.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    Do you just mean a running sum i.e. in the order you currently have for your report add a column that goes 1,2,3...etc?
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Aug 2011
    Posts
    12

    no

    No

    I want a query to rank them in order from highest to lowest showing 1,2,3,4,5 etc as i will use that query to produce a form. to show played won lost points and rank

Posting Permissions

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