Monthly Calendar Report

[Dennis]

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.

 

[Marshall Barton]

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

 

[KARL DEWEY]

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.

 

[Dennis]

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
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.

--
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.

 

[Duane Hookom]

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

--
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
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
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.

--
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.

 

[Dennis]

Yes, and it worked perfectly, thanks!

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

--
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
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
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.

--
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.