Weekly Calendar

[Lori]

I am using Office 2003 and I have everything set up to provide me with Annual
and Monthly Calendars that are perfect when they print. What I need now is a
way to take that same data and present it in a weekly format (for timesheets).

My users are entering their data regularly providing their attendance and I
need to come up with a report (each month) that separates out each week and
gives a total number of hours for the week.

I've looked at other posts on the subject but the links referenced for ideas
are all old and apparently don't exist anymore or have changed.

Any help would be appreciated.

 

[Steve]

Give an example of what you get for Annual and Monthly Calendars then give
an example of what you want for a weekly format then we will be able to help
you. BTW, the "we" does not include visio john and arno r. They are quick to
psot their garbage but never provide help to OPs.

Steve
(e-mail address removed)

 

[Duane Hookom]

I'm not sure how you want a weekly calendar formatted but there are some
sample reports at http://www.access.hookom.net/Samples.htm.

 

[Lori]

Maybe calling it a calendar is the wrong term. I am currently using a
modified version of an annual calendar you pointed me to a long time ago,
that indicates days off for an employee.

I have generated other reports from that to provide me with monthly
calendars by department, location, etc.

What I need is more of a monthly timesheet that separates each week and
provides a weekly total of hours and then a monthly total at the bottom with
a separate page for each employee. I was hoping that I could modify the
calendar I was already using to provide the information I need but I just
can't seem to figure out how.

 

[Duane Hookom]

I'm not sure what format you want to print. Are you expecting to have a
layout where each day of the week are displayed across the page like:
Monday Tuesday Wednesday Thursday Friday

Or do you just want a list of records that groups by employee, month, and
week?

 

[Lori]

I want a line that has the Employee Title (no problem there) with the days of
the week - Sun thru Sat. With the appropriate dates. Underneath the hours
entered that were worked for the specific date and a total by week.