Sort volume

[Guest]

I have a table that tracks staff time and I need to create a report that
outputs a list of users and there time if they have more then 40 hrs per
week. If they have less then ignore them. I have a report that sorts and
outputs the staff and there hours but te key is if the total time is more
then 40 Hrs..

many thanks

Bill

 

[Guest]

Hi Bill

One method would be to use the query the report is based on.

Create a calculated column
Round(DateDiff("n";[TableName]![StartTime];[TableName]![EndTime]) / 60, 0)

This is just an example as this "will" give you a problem as it will round
to the nearest hour. But I am not sure how you record the Start and End
time. Can you give more details and someone will give you a better answer.

Also how are you getting the week ?
Like this >=<Now()-7
or something else ?
eg. are you are only wanting this week or other weeks


Have a look at the answer by Ken Sheridan on this subject
http://groups.google.com/group/micr...rosoft.public.access&rnum=14#fe54d39d0c8d4689

Good luck