Monthly Calendar Report


D

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

Advertisements

M

Marshall Barton

Dennis said:
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
 
K

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

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?

KARL DEWEY said:
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


Dennis said:
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.
 
D

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


Dennis said:
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?

KARL DEWEY said:
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


Dennis said:
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.
 
Ad

Advertisements

D

Dennis

Yes, and it worked perfectly, thanks!

Duane Hookom said:
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


Dennis said:
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?

KARL DEWEY said:
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top