Monthly Calendar Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 26 Dec 2007 22:40 GMT

I have a db with a table that has employee names and dates scheduled for the
year. Could someone please direct me on how to create a report (or even an
examples of reports) that shows a monthly calendar report for the year with
the employee names for each day. There can be several employees of for one
day and I need for all of the names to show under that date. Thanks in
advance for any help you can provide.

Reply to this Message

Marshall Barton - 26 Dec 2007 23:10 GMT

>I have a db with a table that has employee names and dates scheduled for the
>year. Could someone please direct me on how to create a report (or even an
>examples of reports) that shows a monthly calendar report for the year with
>the employee names for each day. There can be several employees of for one
>day and I need for all of the names to show under that date.

There are several examples at:

http://www.access.hookom.net/Samples.htm

Signature

Marsh
MVP [MS Access]

Reply to this Message

KARL DEWEY - 26 Dec 2007 23:31 GMT

Use this query ---
SELECT Format([WorkDate],"yyyy mm") AS Year_Mon, Format([WorkDate],"mmmm
yyyy") AS Year_Month, Format([WorkDate],"yyyy ww") AS Year_Week,
YourDateTable.WorkDate, YourDateTable.Employee
FROM YourDateTable
ORDER BY Format([WorkDate],"yyyy mm"), Format([WorkDate],"yyyy ww"),
YourDateTable.WorkDate, YourDateTable.Employee;
You can omit any part you do not want.

In you report Sorting and Grouping have a header at the level(s) you want -
month/week.

Signature

KARL DEWEY
Build a little - Test a little

> I have a db with a table that has employee names and dates scheduled for the
> year. Could someone please direct me on how to create a report (or even an
> examples of reports) that shows a monthly calendar report for the year with
> the employee names for each day. There can be several employees of for one
> day and I need for all of the names to show under that date. Thanks in
> advance for any help you can provide.

Reply to this Message

Dennis - 27 Dec 2007 03:34 GMT

Hi Karl,
I was able to set up the query but for the report, is there any way to
set it up as a calendar format rather than just a report for a month?

> Use this query ---
> SELECT Format([WorkDate],"yyyy mm") AS Year_Mon, Format([WorkDate],"mmmm
[quoted text clipped - 14 lines]
> > day and I need for all of the names to show under that date. Thanks in
> > advance for any help you can provide.

Reply to this Message

Duane Hookom - 27 Dec 2007 06:16 GMT

Did you check the suggested sample from Marsh's posting?

Signature

Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

> Hi Karl,
> I was able to set up the query but for the report, is there any way to
[quoted text clipped - 18 lines]
> > > day and I need for all of the names to show under that date. Thanks in
> > > advance for any help you can provide.

Reply to this Message

Dennis - 28 Dec 2007 02:17 GMT

Yes, and it worked perfectly, thanks!

> Did you check the suggested sample from Marsh's posting?
>
[quoted text clipped - 20 lines]
> > > > day and I need for all of the names to show under that date. Thanks in
> > > > advance for any help you can provide.

Reply to this Message