Complicated Cross tab query for overtime tracking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 26 Apr 2006 07:32 GMT

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

Reply to this Message

Tom Ellison - 26 Apr 2006 08:23 GMT

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

>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
[quoted text clipped - 7 lines]
>
> Thanks in advance

Reply to this Message

Nick - 26 Apr 2006 15:04 GMT

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:
>
[quoted text clipped - 15 lines]
> >
> > Thanks in advance

Reply to this Message