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'"
Need some help with this Array. I am trying to get the sum of the even numbers and the sum of the odd numbers using a for each loop. I know the answers to what I am trying to achive are sum of even = 84 and the sum of ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...