Gantt Chart that allows for 24hr use to show usage over days

[Colin Richards]

Hi,
I have been struggling for a while working on a Gantt chart to operate as a
Report in Access 2003. In the past I have been pointed to a great example as
displayed at http://www.access.hookom.net/Samples.htm , but the only down
side is that this Gantt example only provides a solution for a 9-5day, I have
had a play with the code but I haven’t managed to allow it to cope with 24hr.

Also I require a Gantt report that displays 7days a week and 24hrs to
display machine availability (usage) that can span across days, can any one
help? As this one has fried my brain.


regards



Colin

 

[Duane Hookom]

The display of the controls in the 9-5 scale is all based on math since all
dates and times are numeric. You would need to modify some of the scale, size
of a minute and other stuff.

There is another report in the demo of a vessel schedule that displays as a
horizontal gantt style. Again, this is all done with basic math determining
how much horizontal and/or vertical space a control will use.