TimeLine Graph in Access

  • Thread starter Thread starter Brian
  • Start date Start date
B

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?
 
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
 
Brian,

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