calculate efficiency

[amna77]

hi can someone help me with query. actually what i am trying to do is, want to calculate efficiency. for example every day operator has to work 6 hours,but in actually he might work 3 or 4 hours per day. the thing where i am stuck is, what should i put in query. i can enter date range for a day, or for a week, or for a month. can u please help me. right now i am keeping track of opertar and hours he worked per day.
Thanks in advance.

 

[PHV]

And what have you so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

How do you define efficiency? Do you have a standard rate of output that you expect and can compare against?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[amna77]

to calculte efficienny, its just 4/6*100 like operator supose to work 6 hours, but actull he worked 4 so 4/6*100. if i enter date for one day then its fine, but the thing is I can enter date for a week or for a month, then how would i do that. like for example if i enter date for 7 days, so it will show me 7 day total.

 

[dhookom]

You could try:
Sum([HoursWorked])/Count([HoursWorked])*6
However the "6" should be stored somewhere and what happens if someone is scheduled to work 6 hours on a day but doesn't work at all? Also, this assumes they would only have one record for each day they work.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[amna77]

Thanks for quick reply. but operator has differnt jobs, like he suppose to run parts for cmm test, he can run 1 part per day or 5 or 10 parts per day, he has to enter time he spent on each part. so at the end of day i calculte the total time.
i can calculate the time, but then how would i put 6 for each day.
thanks

 

[dhookom]

How far have you gotten with this? Do you understand how to create a totals query that groups by employee and date while summing the hours worked? I think this would be a good start.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.