Complicated Cross tab query for overtime tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a cross tab query to track overtime used in a quarter
but I must review it weekly for certain employees and it must sort the
employee's from the lowest to the highest in overtime useage. Field names
are [EmployeeName], [OTdate], [OpportuintiesGiven], and [OThrUsed].
The query must calulate Total [OThrUsed] for quarter and week, Calulate
total [OpportuintiesGiven] for Quarter and Week and Display [OThrUsed] by
date starting with Saturday skipping sunday and Display Monday through
Friday. I want to be able to query any week within the quarter or year.
I may need other fields to do this but am unaware of what is needed.

Thanks in advance
 
Dear Nick:

How about this. Tell us what the data looks like, and what the finished
product should look like. The narrative you've given is pretty thin to work
on any kind of solution.

Tom Ellison
 
Thanks. I will try to explain better. I am entering by "employee name" the
date of the over time given "OTDate" and the amount of time used "OTused".
The query must show the "Employee Name" the sum of the "OTused" for the
current quarter of year" then a break down by Day "OTDate" for 6 days
Saturday through Friday leaving Sunday with a total of overtime "OTused"
for the week. I am at a lose to explain it better. The bigges problem I see
is calulating the total for OTused for the quarter of the current year. I
really hope this helps
Thank you
Dear Nick:

How about this. Tell us what the data looks like, and what the finished
product should look like. The narrative you've given is pretty thin to work
on any kind of solution.

Tom Ellison


Nick said:
I am trying to set up a cross tab query to track overtime used in a quarter
but I must review it weekly for certain employees and it must sort the
employee's from the lowest to the highest in overtime useage. Field names
are [EmployeeName], [OTdate], [OpportuintiesGiven], and [OThrUsed].
The query must calulate Total [OThrUsed] for quarter and week, Calulate
total [OpportuintiesGiven] for Quarter and Week and Display [OThrUsed] by
date starting with Saturday skipping sunday and Display Monday through
Friday. I want to be able to query any week within the quarter or year.
I may need other fields to do this but am unaware of what is needed.

Thanks in advance
Click to expand...
Click to expand...
 
Back
Top