Display as a weekly calendar

[jh3016]

I have a subform that I would like to display the information as a Week-At-A-Glance. My question is two-fold:

1. I would do a query that would ask me the beginning date and then I want the query to display the next 5 days.

2. I want to create a report that would list the 5 days across the page (like a calendar). All dates for Monday would be under Monday. So if the employee took a Monday and Friday off, then their information would appear under Monday and Friday. If the next employee took off Tuesday and Friday, then their info would appear under Tues and Fri. and so on.

The report should have the following fields across the top as column headings: DateTaken, CodeTaken, HrsTaken.

The report should have EEName for the rows.

Is this possible to do? Do you need more info? Thanks in advance

 

[dhookom]

Check

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

to see if any of the sample calendar type reports work for you. There is a week at a glance similar to Outlook.

Duane
MS Access MVP