Recent content by samuelochieng

multiple by department ranking Thanks for your suggestion but i want multiple ranking by department. This should just be an access sql querry.

i have this table and i want an access SQL to rank the employees according to the salary they earn.b1 dept name salary 10 hellen 300 20 ken 200 20 mike 800 10 sam 200 10 susan 200 20 walter 100 this should be the result of that querry pos dept name salary rank 10 hellen 300 1 10 sam 200 2 10...