Rankings

I am struggling to complete a ranking query in my Access database.

What I am trying to do is to rank an employee based on how fast they
complete a given job compared to other employee's. The problem that I
am running into is that I need to rank the employees based on their
location. For example, I have a list of jobs codes, that do not
change, and a list of locations; that do not change. I want to rank
employees based on the employee's work location and job code. Right
now I am writing seperate queries for each job code in each location
and I was wondering if there was an easier way to do this so I don't
have to write a query for each location and each job code. I hope
someone can help and if you need anymore information, please contact
me!

Thanks

re: Rankings

from a post by Henry Craven

Check the MS Knowledgebase for article
Q208946 - How to Rank Records Within a Query




damatoer@hotmail.com (ED) wrote in message news:<add44510.0407300650.689b60ee@posting.google. com>...[color=blue]
> I am struggling to complete a ranking query in my Access database.
>
> What I am trying to do is to rank an employee based on how fast they
> complete a given job compared to other employee's. The problem that I
> am running into is that I need to rank the employees based on their
> location. For example, I have a list of jobs codes, that do not
> change, and a list of locations; that do not change. I want to rank
> employees based on the employee's work location and job code. Right
> now I am writing seperate queries for each job code in each location
> and I was wondering if there was an easier way to do this so I don't
> have to write a query for each location and each job code. I hope
> someone can help and if you need anymore information, please contact
> me!
>
> Thanks[/color]

re: Rankings

I have looked at that article and that is how I have been able to rank
my results so far. The problem that I have is that the example ranks
everything as one in the same. It takes the total count and ranks all
the products based on that total count.

Whereas, in my example I want to be able to rank the avg job time based
on where the job was completed. I currently have 5 locations an 10 main
jobs that are completed in each location. The job code remains the same
for each location. Right now the way that I am raqnking each location
and job code is to create seperate queries that calculate the avg job
time and count based on the location and the job code. Which means that
I would have to write a seperate query for each job code in each
location. I was wondering if there was a way to be able to accomplish
this through one query?

Does this make sense?

Thanks again



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!