ranking with many condition (1 Viewer)

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
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: 71

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:10
Joined
May 7, 2009
Messages
15,037
see if this is what you need
 

Attachments

  • rank.accdb
    648 KB · Views: 71

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
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: 71

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:10
Joined
May 7, 2009
Messages
15,037
Here, i add the sort order.
 

Attachments

  • rank.accdb
    684 KB · Views: 68

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
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, 23:10
Joined
May 7, 2009
Messages
15,037
check this db.
 

Attachments

  • rank.accdb
    1.7 MB · Views: 76

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
thanks for your response

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

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
please update rank per each group in query qryFiltered
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:10
Joined
May 7, 2009
Messages
15,037
check this hatmak.
 

Attachments

  • rank.accdb
    716 KB · Views: 77

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
when I open qryFiltered
 

Attachments

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

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
as attached
 

Attachments

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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:10
Joined
May 7, 2009
Messages
15,037
check your Sorting on your post#3.
that is the current Ranking already.
 

hatmak

Registered User.
Local time
Today, 07:10
Joined
Jan 17, 2015
Messages
90
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, 07:10
Joined
Jan 17, 2015
Messages
90
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: 65
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:10
Joined
May 7, 2009
Messages
15,037
hatmak, i am posting again the previous db.
 

Attachments

  • rank.accdb
    716 KB · Views: 72

Users who are viewing this thread

Top Bottom