I have an attendance database, with fields for males, females, total sum of the males and females and location. The location is the field for locations submitting the attendance. Now, a location can submit attendance as many times as possible, how can I do it in such a way that all the total attendance for a particular location would be summed up together and represented in a chart to show the location with the highest attendance. How can I do it??? Thanks 
in advance
Watch this wideo tutorial https://youtu.be/3eX56jsPbas
In the middle part he show how to group and sort things on chart.
I learnd form it how to group and show my monthly usage chart.
This topic was automatically closed after 69 days. New replies are no longer allowed.