A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Weekly Calendar



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 08:56 PM posted to microsoft.public.access.reports
Lori
external usenet poster
 
Posts: 673
Default 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.

Ads
  #3  
Old May 15th, 2010, 06:01 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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  
Old May 19th, 2010, 02:25 PM posted to microsoft.public.access.reports
Lori
external usenet poster
 
Posts: 673
Default 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  
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.

  #6  
Old May 19th, 2010, 09:23 PM posted to microsoft.public.access.reports
Lori
external usenet poster
 
Posts: 673
Default 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  
Old May 19th, 2010, 10:02 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.