How to visually represent the start and end dates of projects in a chart

Posted on 2005-04-19
Last Modified: 2012-06-27
In an Access 2003 database I have a number of projects being run. Each project has a start date and an end date. The end date will often change and users need to be able to look at a chart and see how many projects are running at any one time, how many project starts there are in any given month and how many project ends.

What I need is a chart with projects listed in rows on the left and months of the year as columns. The projects should be represented as lines passing through the months. So, it the chart is displaying January to December, a project starting mid-February and ending in October should show up as a line starting and finishing in those months.

Can anyone suggest how to approach this?
Question by:richardbarlow
    1 Comment
    LVL 39

    Accepted Solution

    Take a look at the Crew Rotation Schedule in Calendar.Zip at (Click on the two file folders icon  in the top left corner under the word download.)  I think that is exactly what you are looking for.


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now