If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Weekly Calendar
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. |
#2
|
|||
|
|||
Weekly Calendar
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 "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. |
#3
|
|||
|
|||
Weekly Calendar
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. |
#4
|
|||
|
|||
Weekly Calendar
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
Weekly Calendar
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. "Duane Hookom" wrote: 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. |
#7
|
|||
|
|||
Weekly Calendar
So apparently my layout is almost exactly what you want but with weekend days
and a total? I would base the report on a crosstab that has the weekday as the column heading. You could group by employee, month, and week as a row headings. -- Duane Hookom Microsoft Access MVP "Lori" wrote: 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. "Duane Hookom" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|