D
doodle
Greetings all. Windows xp, Access 97
I have a report that contains two charts. Because of the bug in 97
(sample data), I originally created the charts in a form and copied
them to my report. The charts were working fine. Today the charts still
look great in Preview, but in design view, the chart object is
completely blank. I can still see the data source and the chart title,
but that's all. If I go into MS Graph to edit the chart, also blank. I
need to change the scale on one of the charts and have no way to get to
it.
HELP!!! (Please don't tell me that this is a freak 97 thing...)
-doodle
Oh... here's my chart source:
Chart 1:
SELECT qryCL_MonthJoin5.Subject, Count(*) AS Count
FROM qryCL_MonthJoin5
GROUP BY qryCL_MonthJoin5.Subject;
Chart 2:
TRANSFORM Count(qryCL_MonthJoin6.CallID) AS CountOfCallID
SELECT qryCL_MonthJoin6.SourceType
FROM qryCL_MonthJoin6
GROUP BY qryCL_MonthJoin6.SourceType
PIVOT qryCL_MonthJoin6.Subject;
I have a report that contains two charts. Because of the bug in 97
(sample data), I originally created the charts in a form and copied
them to my report. The charts were working fine. Today the charts still
look great in Preview, but in design view, the chart object is
completely blank. I can still see the data source and the chart title,
but that's all. If I go into MS Graph to edit the chart, also blank. I
need to change the scale on one of the charts and have no way to get to
it.
HELP!!! (Please don't tell me that this is a freak 97 thing...)
-doodle
Oh... here's my chart source:
Chart 1:
SELECT qryCL_MonthJoin5.Subject, Count(*) AS Count
FROM qryCL_MonthJoin5
GROUP BY qryCL_MonthJoin5.Subject;
Chart 2:
TRANSFORM Count(qryCL_MonthJoin6.CallID) AS CountOfCallID
SELECT qryCL_MonthJoin6.SourceType
FROM qryCL_MonthJoin6
GROUP BY qryCL_MonthJoin6.SourceType
PIVOT qryCL_MonthJoin6.Subject;