reports by year

S

sweetummy

i have a table named - studentsinfo

stuname, city, college, course,1styear,2ndyear,(all in 1 table)
3rdyear,expenditure-1,expenditure-2, expenditure -3 ....

xyz, xyzcity, zyxcollege, BA, 2007, 2008, 2009, 2000,2000,2000
now i would like to display on reports by year - 2009
i have nearly 1000 records..starting from 2005 year..

the next year coming student falls in first year and his year of study
will be 2010 , is it tedious to extract the report.by year..
i got the problem in extraction of year and expenditure by their year
of study..
i would like my report like this..

academic year - expenditure amount
2009 2010 Exp-1, exp 2
i ii 2000, 2000

i want to display the records only 2009 records how please tell me..
each year i have to update their records by adding their year of
study and expenditure .. any suggestions plz...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top