Cross tab query I think but do not know how to do it.

N

Nick

I want to build a query for tracking over time. I like it to calulate total
hour for the week and the quarter. it should show the date for the days of
the week and the hours of overtime worked by each employee for that date. It
should also count the opportunities given with the hours of overtime they
refused. The table includes EmployeeID, EmployeeName, Oppourunities,
HoursWorked, HoursRefused and DateOfOt.
 

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

Top