gantt chart in Access 2003

[Guest]

Hi, I'm trying to have a gantt chart created from data in this format:
Tape_Drive Start_time End_time
tape_drive_1 01/01/2005 1:00am 01/01/2005 2:00am
tape_drive_1 01/01/2005 4:30am 01/01/2005 5:00am
tape_drive_2 01/01/2005 3:00am 01/01/2005 4:00am

As you can see the tape drives may be repeated, and I'm trying to get a
floating bar chart, showing the tape drive start/stop usage for some
particular date.
I found the exact visual basic code for doing this in excel at
http://www.lacher.com/examples/lacher24.htm but have not been able to make
any progress converting it to access. Is there a tool to convert VB in excel
to Access?

 

[PC Datasheet]

If you need outside help with this, send me an email at my email address
below.

 

[Duane Hookom]

Check the calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is one that
resembles a gantt chart.