I need to create a crosstab query and need some assistance.
Assistance is provided to employees to pursue their studies for the duration of the course of study. So if I am doing an undergrad degree which will take me 4 years, I will receive funding each year of those 4 years.
What I need is to have a report which will display details about the employee receiving the funding and also a breakdown of the funds to be disbursed each year.
So if my degree starts in 2011 and finishes in 2015 and I am receiving $8,000.00 in funding, I need to see each year as a column header and $2,000.00 for each year. You are given the amount requested divided by the number of years of study ($8,000/4=$2,000.00). However, a maximum of $2,000.00 per year is given.
So to summarise, I need to see the difference in years between the start date and end date of the course of study as column headers and the amount granted divided by the number of years for each year.