Results 1 to 2 of 2
  1. 03-22-2012, 06:23 PM #1
    Andyjones
    Andyjones is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    76

    Help With Ramking

    Hi Realy Need help with this query. I have a query called query 1 that calcualtes the rank of each player by points, however instead of going 122356 etc i want it to go 112345 or if someone has the same points shows = as in =1st place. the tie break if two players would be plus.minus field like you would have in a football league table. i dealy want it to rank 1123345 etc Im no good at coding so if anyone know who to do this please adjust query 1 as you see fit you help would be much apreciated/
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 03-26-2012, 01:44 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    You may get more help if you post your db in the mdb format.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

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