AnsweredAssumed Answered

Ranking records without ascending order

Question asked by LeonLay on Mar 24, 2013
Latest reply on Mar 28, 2013 by LeonLay

Title

Ranking records without ascending order

Post

     I've tried to search the forum to find out a way to rank a field without shorted the field, but I didn't see it.

     Here's my request: 

Table 1 is info about client, like

     NAME │CLIENT_ID │ADDRESS │PHONE │etc.

     Tom    │0715           │XXX            │1234      │etc.

     ==========================

Table 2 is info about users pay info

     CLIENT_ID │ QUANTITY │AMOUNT │ RANK

     0715           │16                │$19.99      │rank number

     And now put them in one layout(Table 1) to show the Client's overview, but when I put the RANK field into Table 1's layout, the RANK field desn't work( seems it only worked in Table 2).

     All I want is to short with the NAME field while it shows each NAME's Ranking number.

     Could this possible?

Outcomes