TimeLine Graph in Access

[Brian]

Does anyone know how to create a timeline graph as an
Access report, pulling data from an Access database. I
have a database with the following fields: Task,
StartDate, EndDate. There are multiple tasks (up to a max
of about 100) for each project. I want to be able to
print a chart that shows each task for a particular job,
with a bar graph from StartDate to EndDate. This would
enable us to see if there are overlapping tasks that
shouldn't be overlapping.

Any suggestions?

 

[Andrew King]

Hi Brian,

Go to the following link and download the zip file.
This file contains an Access 97 database with a simple
table and a sample report that has 2 functions -
1). Calculate the number of days between a Start and End
date
2). For each record, position a rectangle to the
appropriate starting date and then resize it to take into
account the number of days duration compared to the value
calculated in step 1.

http://www.mvps.org/access/reports/rpt0018.htm

HTH,

Andrew King

 

[PC Datasheet]

Brian,

I can do this for you! If you would like my help, contact me at the email
address below.