ranking with many condition (1 Viewer)

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
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

  • rank.accdb
    1.1 MB · Views: 46

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
see if this is what you need
 

Attachments

  • rank.accdb
    648 KB · Views: 47

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
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: 47

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
Here, i add the sort order.
 

Attachments

  • rank.accdb
    684 KB · Views: 44

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
check this db.
 

Attachments

  • rank.accdb
    1.7 MB · Views: 52

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
thanks for your response

please update rank per each group in query qryFiltered
 
Last edited:

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
please update rank per each group in query qryFiltered
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
check this hatmak.
 

Attachments

  • rank.accdb
    716 KB · Views: 51

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
when I open qryFiltered
 

Attachments

  • 1.png
    1.png
    56.3 KB · Views: 42

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
as attached
 

Attachments

  • 2.png
    2.png
    39 KB · Views: 43

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
check your Sorting on your post#3.
that is the current Ranking already.
 

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
I mean serial no. for ranking
to be like
1
2
3

not as file attached is

1
2
4
 

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
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: 41
Last edited:

hatmak

Registered User.
Local time
Yesterday, 16:47
Joined
Jan 17, 2015
Messages
84
i want ranking variable for any select
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:47
Joined
May 7, 2009
Messages
14,556
hatmak, i am posting again the previous db.
 

Attachments

  • rank.accdb
    716 KB · Views: 48

Users who are viewing this thread

Top Bottom