J
Jeff Popp
I'm using Access 2000 running on XP Pro. I have used VBA
and can work with it; however, I need guidance relating
to my problem below. VBA may not be the answer? Any
suggestions are very appreciated.
I have 416 school district records. I need to create a
six-page report for each record. Each page has at least
one chart. Each chart will have at least one, and as
much as four, data points unique to that district record
with a paired comparator point for each district point
from the state education department.
I want a simple bar chart displaying the comparison
between each set of data points with some text commenting
on the results below the chart. For example, college
going rates to the University of California system for
the district compared to that for the state; college
going rates to the Cal State University system for the
district compared to that for the state... If needed, I
could have individual charts for each data pair, so I
would have say three charts on a page where three
pairings existed on a specific point.
I've tried using the MS Graph Chart 2000 control, but
when I specify the RowSource Type as Table/Query, I can't
get the values to show. I've also looked into using
Excel, but the need for 416 distinct reports sent me back
to Access.
I'm open to any suggestions at this point, upgrading to
Access 2003, using another tool... Any suggestions
welcomed.
and can work with it; however, I need guidance relating
to my problem below. VBA may not be the answer? Any
suggestions are very appreciated.
I have 416 school district records. I need to create a
six-page report for each record. Each page has at least
one chart. Each chart will have at least one, and as
much as four, data points unique to that district record
with a paired comparator point for each district point
from the state education department.
I want a simple bar chart displaying the comparison
between each set of data points with some text commenting
on the results below the chart. For example, college
going rates to the University of California system for
the district compared to that for the state; college
going rates to the Cal State University system for the
district compared to that for the state... If needed, I
could have individual charts for each data pair, so I
would have say three charts on a page where three
pairings existed on a specific point.
I've tried using the MS Graph Chart 2000 control, but
when I specify the RowSource Type as Table/Query, I can't
get the values to show. I've also looked into using
Excel, but the need for 416 distinct reports sent me back
to Access.
I'm open to any suggestions at this point, upgrading to
Access 2003, using another tool... Any suggestions
welcomed.