Charts/graphs on Access forms and reports

I have been given a project where I have to create a chart on a form and
duplicate it on a report.
There are three dates that are sequential that need to be charted for each
item.
So each "row" on the chart will show a triangle for the start date of each
step in the process.
However, each date has an estimated and actual date.
I need to draw a line between the actual and estimated for each date, with a
space before the next estimated and actual. e.g. (where # would be the
triangle)

Task F F M A M J J A S O N D
TASK ONE #-------# #--------------# #--#
TASK TWO #----# #------------# #--#

or I might get away with two lines per task:
Task F F M A M J J A S O N D
TASK ONE Est # # #
TASK ONE Act # # #

and somehow color code the estimated and actual for each date.

I think the triangle idea comes from MS Project charts, but they don't use
Project.
Where can I find some good examples of how this might be done in Access
2007?

For reports, I would use the methods from the calendar reports found at
http://www.access.hookom.net/Samples.htm.
For the forms, I would look at concatenating strings of characters together.
Otherwise, there are third party controls you could purchase that might work
well.


--
Duane Hookom
MS Access MVP


"M Skabialka" wrote in message
...
I have been given a project where I have to create a chart on a form and
duplicate it on a report.
There are three dates that are sequential that need to be charted for each
item.
So each "row" on the chart will show a triangle for the start date of each
step in the process.
However, each date has an estimated and actual date.
I need to draw a line between the actual and estimated for each date, with
a space before the next estimated and actual. e.g. (where # would be the
triangle)

Task F F M A M J J A S O N D
TASK ONE #-------# #--------------# #--#
TASK TWO #----# #------------# #--#

or I might get away with two lines per task:
Task F F M A M J J A S O N D
TASK ONE Est # # #
TASK ONE Act # # #

and somehow color code the estimated and actual for each date.

I think the triangle idea comes from MS Project charts, but they don't use
Project.
Where can I find some good examples of how this might be done in Access
2007?

Possibly the rotation schedule format for the report, but they want
something on a form. In fact the form will have four areas, each reporting
current status, schedules or graphs of different aspects of the
organization. The user wants to be able to select items on this form and
open other forms to make changes, with the main form always showing the most
current status.

While going through my old databases (1990s), I found one that has gantt
charts on the forms which look as though they were pulled from MS Project.
I have converted it to Access 2007.
As I navigate the records the gantt chart changes to reflect different data.
I didn't write this database, and don't have Project installed, and don't
know the gantt chart was added to the form.
The Control Source for the chart object is gantt which is a field in the
table, and in the table says MSProject.Project.8 on every record for the
gantt field. I can't see what is stored in that field other than the name
MSProject.Project.8.
There are no events associated with the form.

I have a copy of Project 2003 which I can install if needed.
Since these forms with gantt charts seem very close to what I need, can
anyone give me some advice on what I need to know in order to create a table
and/or form and put gantt charts on the form reflecting data in the
database? And probably put the gantt chart on reports also.
I am using Access 2007.

Thanks,
Mich

"Duane Hookom" wrote in message
...
For reports, I would use the methods from the calendar reports found at
http://www.access.hookom.net/Samples.htm.
For the forms, I would look at concatenating strings of characters
together. Otherwise, there are third party controls you could purchase
that might work well.


--
Duane Hookom
MS Access MVP


"M Skabialka" wrote in message
...
I have been given a project where I have to create a chart on a form and
duplicate it on a report.
There are three dates that are sequential that need to be charted for
each item.
So each "row" on the chart will show a triangle for the start date of
each step in the process.
However, each date has an estimated and actual date.
I need to draw a line between the actual and estimated for each date,
with a space before the next estimated and actual. e.g. (where # would be
the triangle)

Task F F M A M J J A S O N D
TASK ONE #-------# #--------------# #--#
TASK TWO #----# #------------# #--#

or I might get away with two lines per task:
Task F F M A M J J A S O N D
TASK ONE Est # # #
TASK ONE Act # # #

and somehow color code the estimated and actual for each date.

I think the triangle idea comes from MS Project charts, but they don't
use Project.
Where can I find some good examples of how this might be done in Access
2007?

Again, I would search for a third party control. A quick search found
http://www.exontrol.com/exg2antt.jsp. I know there are many others.

--
Duane Hookom
MS Access MVP


"M Skabialka" wrote in message
...
Possibly the rotation schedule format for the report, but they want
something on a form. In fact the form will have four areas, each
reporting current status, schedules or graphs of different aspects of the
organization. The user wants to be able to select items on this form and
open other forms to make changes, with the main form always showing the
most current status.

While going through my old databases (1990s), I found one that has gantt
charts on the forms which look as though they were pulled from MS Project.
I have converted it to Access 2007.
As I navigate the records the gantt chart changes to reflect different
data.
I didn't write this database, and don't have Project installed, and don't
know the gantt chart was added to the form.
The Control Source for the chart object is gantt which is a field in the
table, and in the table says MSProject.Project.8 on every record for the
gantt field. I can't see what is stored in that field other than the name
MSProject.Project.8.
There are no events associated with the form.

I have a copy of Project 2003 which I can install if needed.
Since these forms with gantt charts seem very close to what I need, can
anyone give me some advice on what I need to know in order to create a
table and/or form and put gantt charts on the form reflecting data in the
database? And probably put the gantt chart on reports also.
I am using Access 2007.

Thanks,
Mich

"Duane Hookom" wrote in message
...
For reports, I would use the methods from the calendar reports found at
http://www.access.hookom.net/Samples.htm.
For the forms, I would look at concatenating strings of characters
together. Otherwise, there are third party controls you could purchase
that might work well.


--
Duane Hookom
MS Access MVP


"M Skabialka" wrote in message
...
I have been given a project where I have to create a chart on a form and
duplicate it on a report.
There are three dates that are sequential that need to be charted for
each item.
So each "row" on the chart will show a triangle for the start date of
each step in the process.
However, each date has an estimated and actual date.
I need to draw a line between the actual and estimated for each date,
with a space before the next estimated and actual. e.g. (where # would
be the triangle)

Task F F M A M J J A S O N D
TASK ONE #-------# #--------------# #--#
TASK TWO #----# #------------# #--#

or I might get away with two lines per task:
Task F F M A M J J A S O N D
TASK ONE Est # # #
TASK ONE Act # # #

and somehow color code the estimated and actual for each date.

I think the triangle idea comes from MS Project charts, but they don't
use Project.
Where can I find some good examples of how this might be done in Access
2007?