A question about a form with a graph/chart



I have a graph on a form. The form has no datasource. The graph's
rowsource is a table/query:

SELECT qryLevelsAll.Week_of, Avg(qryLevelsAll.Level) AS AvgOfLevel
FROM qryLevelsAll
GROUP BY qryLevelsAll.Week_of
ORDER BY qryLevelsAll.Week_of;

When this SQL is executed I get two rows:

Week_of AvgOfLevel
9/5/2011 2.575
9/12/2011 2.8

When I remove the average and Group By I get 6 rows:

Week_of Level
9/5/2011 2.7
9/5/2011 2.6
9/5/2011 2.5
9/5/2011 2.5
9/12/2011 2.8

I would expect the chart to show points across the bottom, 9/5/2011 and
9/12/2011. Instead I get the EIGHT dates from 9/5 through 9/12.

Can anyone tell me what I'm doing wrong?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question