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
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