Horizontal data question

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

Guest

The report I need is to run the data horizontaly of all emplyees on one page
and it must report Saturday, Monday, Tuesday, Wedensday, and so on excluding
Sunday, then calculate total hours used by Employee.
Example: Sat: Mon: Tue: Wed:
EmployeeName OTdate OTdate OTdate OTdate
Hourwork Hourwork Hourwork Hourwork Total
OT Hours
The data base has to know the Saturday date for each week.
 
You can use a crosstab query with Column Headings of the WeekDay.
 
You must log in or register to reply here.

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
How to count records w/o counting duplicates by week, month, or ye 4
Networkdays including Saturday? 5
multiple critera formula 3
Adding Multiple Lines when the Function is Satisfied 1
Formulas--NEED HELP! 4
Outlook weekly view 1
Clearing scheduled work hours for weekends 6

Back
Top