Try again

N

Nick

I am tring to construct a weekly crosstab query for a given quarter but I
must be able to calulate totals hours for the weeks in quarter and also total
hours for current week. I am using the following fields. EmployeeID, DateOt,
and HourUse.
 
D

Duane Hookom

How do you expect to handle weeks that start in one quarter and end in
another?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Cross tab query for overtime tracking 2
Cross tab query I think but do not know how to do it. 0
Resource Pool changes actual hours in 2010 0
Need some PWA help 0
Custom Number sequences 0
Crosstab Query Omitting Some Items 1
Is there a way to make positive numbers appear as +XX ? 4
How to count records w/o counting duplicates by week, month, or ye 4

Top