Without seeing your data we can not answer the question effectively.
One method would be to write queriest to select the data you wish to receive based on a date field.
"SELECT * FROM MyTable WHERE MyDateCol BETWEEN '01/01/2014 01:01:01' AND '12/31/2014 23:59:59'"
"SELECT * FROM MyTable WHERE MyDateCol BETWEEN '01/01/2015 01:01:01' AND '12/31/2015 23:59:59'"
in my program there will be one popup show select accademic year if the select some year then accourding to that year student list sholud display. i didnt mention any date on "student report" (my data table name)
You can do this in a query if the values that you are looking for are consistant.
'This will get the total number of rows.
"SELECT Count(*) FROM tblStudents WHERE MyCol1='MyVal' AND MyCol2='MyVal'"
'This will give a sum
"SELECT Sum(MyColToSum) FROM tblStudents WHERE MyCol1='MyVal' AND MyCol2='MyVal'"