ranking with many condition (1 Viewer)

hatmak

Registered User.
Local time
Today, 16:55
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

  • rank.accdb
    1.1 MB · Views: 288

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
see if this is what you need
 

Attachments

  • rank.accdb
    648 KB · Views: 285

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
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: 284

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
Here, i add the sort order.
 

Attachments

  • rank.accdb
    684 KB · Views: 294

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
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
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
check this db.
 

Attachments

  • rank.accdb
    1.7 MB · Views: 291

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
thanks for your response

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

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
please update rank per each group in query qryFiltered
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
check this hatmak.
 

Attachments

  • rank.accdb
    716 KB · Views: 304

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
when I open qryFiltered
 

Attachments

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

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
as attached
 

Attachments

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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
check your Sorting on your post#3.
that is the current Ranking already.
 

hatmak

Registered User.
Local time
Today, 16:55
Joined
Jan 17, 2015
Messages
121
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
Today, 16:55
Joined
Jan 17, 2015
Messages
121
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: 287
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:55
Joined
May 7, 2009
Messages
19,169
hatmak, i am posting again the previous db.
 

Attachments

  • rank.accdb
    716 KB · Views: 300

Users who are viewing this thread

Top Bottom