By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Blank Charts

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.