Charts from queries

[rcoreejes]

Hi, I don't seem to get it right to use a chart in my reports from a query.
See attached database. I want to create a chart in the report to give visual feedback to the user.
Could somebody help me with this and give me a step-by-step explanation how to do this?

[June7]

You mean a graph? What data do you want to plot? What do you want it to look like - pie, bar, line?

If you want to show all parties on the report even if there were no votes, need to change the join type of the query from INNER to LEFT:

SELECT DISTINCTROW Candidates.CandidatesPartyName, Sum(Votes.VotesValue) AS [Sum Of VotesValue]
FROM Candidates LEFT JOIN Votes ON Candidates.[CandidatesNumber] = Votes.[VotesPartyName]
GROUP BY Candidates.CandidatesPartyName
ORDER BY Sum(Votes.VotesValue) DESC;

Suggest the candidate name and vote sum both go in the group header.

[rcoreejes]

Yes, a bar-graph.
I want to create the graph in access's report, just like you do in excel.
Attached is the result I want, like in excel, but don't know how to do it in access.

[June7]

Try:

1. create a bar graph in the report header, doesn't matter how you set it up with the wizard, just get the graph object on the report

2. change the graph RowSource to:
SELECT [CandidatesPartyName], [Sum Of VotesValue] FROM [Candidates_Query];

3. open in layout view and save the report

4. return to design view and set graph properties as desired

With the previously suggested changes, all of the candidates will show on graph.

[rcoreejes]

Thanks a lot. It's working perfectly