Blank Charts

[Andy]

I have a simple query that basically pulls in an employee's name, and
3 different scores. I am trying to make a report where each employee
shows up on a different page, and the 3 scores are shown in a bar
graph. The simple bar graph is set up like I need it to, but when I
link the master/child fields, the graph turns out blank. I remove the
link, and the full graph shows up. I want the graph to show that one
employee's scores on that page, the next employee on the next page,
etc. I have a grouping level at [Name], and 'Force new page' after the
Name footer section. I have the [Name] field in the detail section of
the report for the link. The SQL query for the graph is:
SELECT [e11 - Add Date Range Into Results].Name,
[e11 - Add Date Range Into Results].SCORE1,
[e11 - Add Date Range Into Results].SCORE2,
[e11 - Add Date Range Into Results].SCORE3
FROM [e11 - Add Date Range Into Results];

I am using Access 97. What am I missing?? Thanks for your help.

[HS Hartkamp]

I have a working graph in my database without really understanding the way
graphs work. All done by trial and error, so I cant tell you what is needed.
I can tell you what I have: a standard query without the " - Add Date Range
Into Results" bit.

Perhaps that's what you need also. Note that you might have to add a
ctlGraph.Requery somewhere in your code (e.g. in the Form_Current event)

Bas Hartkamp.

Andy <an******@accesstoledo.com> schreef in berichtnieuws
68**************************@posting.google.com...

I have a simple query that basically pulls in an employee's name, and
3 different scores. I am trying to make a report where each employee
shows up on a different page, and the 3 scores are shown in a bar
graph. The simple bar graph is set up like I need it to, but when I
link the master/child fields, the graph turns out blank. I remove the
link, and the full graph shows up. I want the graph to show that one
employee's scores on that page, the next employee on the next page,
etc. I have a grouping level at [Name], and 'Force new page' after the
Name footer section. I have the [Name] field in the detail section of
the report for the link. The SQL query for the graph is:
SELECT [e11 - Add Date Range Into Results].Name,
[e11 - Add Date Range Into Results].SCORE1,
[e11 - Add Date Range Into Results].SCORE2,
[e11 - Add Date Range Into Results].SCORE3
FROM [e11 - Add Date Range Into Results];

I am using Access 97. What am I missing?? Thanks for your help.