Results 1 to 2 of 2

Thread: Crosstab Query

  1. #1
    Join Date
    Mar 2012

    Unanswered: Crosstab Query


    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.

    Thanks in advance for any help.

  2. #2
    Join Date
    Mar 2012

    Sample Output

    I have attached a clip to show what I am looking for.

    Attached Thumbnails Attached Thumbnails Sample of Required Output.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts