create report of daily hours shown weekly

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

I have a database that allows us to input daily hours worked on specific
projects. We need to create a report that shows each member and the total
hours worked on a weekly basis. When I use grouping it shows each each
individual record.

We would like to see week1 for employee1 equals weekshours instead of each
daily record.

Is there a simple way to query or create this report

Thanks
Chris
 
Hi CP,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You can use a Totals query to build the data for this report.

1-Create new Query in Design View based on the table with all the records.
2-Add fields in the following order (left to right in the grid)
WeekNum: Week([NameOFDateField])
ProjectID
EmployeeID
WorkHours

The first column, WeekNum: is a calculated field to change the value of
your date field into a week number for grouping. The other fields will have
to match your field names.
3-Click on the Totals button which will add the Total line to the query
grid.
4-By default it will set the above fields (columns) to GroupBy. Only
change the last field, WorkHours, to SUM

What this query should then do is group your data by Week, Project,
Employee giving you one line for each employee, for each project, for each
week.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Thanks for the pointer

However I couldn't seem to get your expression WeekNum:
Week([NameOFDateField]) to work kept coming up with undefined function. I am
using Access 2000. Nothing in the help files or Knowledge Base. On doing a
bit of digging in the news groups found the following weeknum: format
([NameofDateField], "ww") which seems to work. Any comments appreciated.

Thanks
Chris
 
Hi CP,

Sorry, my bad. The example you found is correct.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top