Annual Calendar Report

[kwor]

I have a table recording people and projects. The table has people's names, start date and end date of each project.
Each person may have several projects throughout the year.

I need to generate a report that will display an entire year (each month?) across the page. Each person's name would be displayed on the left side of the page and a "bar" representing each project for the year would be shown at the appropriate "place" across the year.

I have searched many places but cannot find anything similar. I would appreciate any help in getting started.

 

[dhookom]

Check out calendar reports. There is at least one that matches your requirements.

Duane
Hook'D on Access
MS Access MVP

 

[kwor]

Hmmm....I did look at your site early on. I missed the Gantt Chart. Thanks for sending me back again. I will work from that.