View Full Version : Graph Reports


ChrisAccessDB01
05-02-2008, 02:37 AM
I want to create Graphs inside My Reports the graphs are based on a query that has questionnaire results in it currently we have a report that lists the percentages
these are the calculations from the report it takes a count of the monitoring period (which is entered by the user) and then works out the totals.
=Sum([S1Q1very])/Count([Monitoring Period])
=Sum([S1Q1acceptable])/Count([Monitoring Period])
=Sum([S1Q1difficult])/Count([Monitoring Period])
=Sum([S1Q1na])/Count([Monitoring Period])

I want to put these figures in the graph but i have no idea how?
It would be much easier than modifying my query i have tried that already and I don't know how to get the correct result.
thanks for looking
Chris

apr pillai
05-09-2008, 11:09 AM
Try these links:

http://www.msaccesstips.com/2007/08/ms-access-and-graph-charts.shtml
http://www.msaccesstips.com/2007/09/ms-access-and-graph-charts2.shtml