i have build up an application for a school using ms access.
there are many catagories in a school.SUch as civil ,eymploys,soldiers. i have generated a report and find the sum for each catagory in class that how many students are there in each class
for example class four have 50 students
class civil mil offcers total

four 33 8 9 50
i have got value 50 by adding [civil]+[mil]+[offcers] now i want to get sum of total and want to know total strength but in office-2007 the sum is not highlighted is there any method to get total of already calculted sums .
please help me i am waiting for your urgent reply