AnsweredAssumed Answered

Need help figuring out how to do this calculation for a report

Question asked by Victor on May 14, 2009
Latest reply on May 14, 2009 by comment_1

Title

Need help figuring out how to do this calculation for a report

Post

Hello,

 

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. 

 

thank you

Vic 

Outcomes