Thread: Weekly Calendar
View Single Post
  #5  
Old May 19th, 2010, 04:25 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Weekly Calendar

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?

--
Duane Hookom
Microsoft Access MVP


"Lori" wrote:

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" wrote:

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.

--
Duane Hookom
MS Access MVP


"Lori" wrote in message
...
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.