Need help figuring out how to do this calculation for a report
Basically i have student database with students hours, city, program, student id. I am trying to find out what the total of hours attended base of hour range are for a city,example of the hours range i am looking to do is 1-60 hrs, 61-200, 351-450. my field are: total_allhours, student name, student id, city.
so i want to show: city a, 1-60=20 students with that range of hours attended, 61-200=10 student with that range of hours attended
total of all hours are been calculate by the field total_allhours.