ranking with many condition (1 Viewer)

hatmak

Registered User.
Local time
Yesterday, 20:25
Joined
Jan 17, 2015
Messages
121
good day for all

please help in following


In company we have a lot of employee

Company make summer resort to many place

Like place 1 ,place 2, place 3…

And we want to get ranking for each employee depend on many rules

If many employee select place1 and group1

I want ranking employees for place1 and group1

If employee select place 1 and group2

I want ranking employees for place1 and group2

If employee select place 2 and group1

I want ranking employees for place2 and group1



This ranking depend on

Respectively



The first

Points given to employee which are in table EMP_POINT_TB

Than

The second

Position

which are in table emp_tb

and if them I same position I need to compare them with date promotion

and if in same of promotion date compare with the hiring date
 

Attachments

see if this is what you need
 

Attachments

thanks for your response arnegp

but I want to add rank field in query

as attached
 

Attachments

  • rank.jpg
    rank.jpg
    160.6 KB · Views: 365
Here, i add the sort order.
 

Attachments

any thanks arnegp

could you please add this rank to query

and this filed is sort like

ranks field
1
2
3
1
2
for
foe each employee
 
thanks for your response

please update rank per each group in query qryFiltered
 
Last edited:
please update rank per each group in query qryFiltered
 
check this hatmak.
 

Attachments

when I open qryFiltered
 

Attachments

  • 1.png
    1.png
    56.3 KB · Views: 380
as attached
 

Attachments

  • 2.png
    2.png
    39 KB · Views: 375
check your Sorting on your post#3.
that is the current Ranking already.
 
I mean serial no. for ranking
to be like
1
2
3

not as file attached is

1
2
4
 
and when I select any
place 1 or 2
without select group

the rank field automatic change ranking number
1
2
3
4
5
 

Attachments

  • 3.png
    3.png
    30.3 KB · Views: 371
Last edited:
hatmak, i am posting again the previous db.
 

Attachments

Users who are viewing this thread

Back
Top Bottom