Scholarship Table Analysis

[akpofureenughwu]

Hello everyone,

I am working on a scholarship report that I need to add a select feature based on the student course of study

In the design, we will use the session filter (2000/2001) to select student who are valid to receive scholarship payment each session.

For example, using the table below

                    In Session 2000/2001  John and Flowers are eligible for payment

                    In Session 2002/2003  All Candidate are eligible for payment

                    In Session 2007/2008 Only Dede is eligible for payment

S/N	Name	Sex	School	Session	Course of Study	Duration
1	John Brown	Male	Jim High School	2000/2001	Fine Art	6
2	Eze Francis	Male	St. Pauli University	2001/2002	Engineering	5
3	Dede Chi	Female	St. Pauli University	2002/2003	Medicine	6
4	Flowers Kepp	Female	St. Pauli University	2000/2001	Geology	4

Thank you

[akpofureenughwu]

antoniotiman mancinitiman  stalwar1‌

Hello sir,

I just discovered a bug in this script.

For the Eligible session, It gives the exact number +1 year

For Flower Kepp's Profile in the attached app, His course duration is four year ie  2000/2001, 2001/2002, 2002/2003, 2003/2004

But if you filter with the Eligible filter, 2004/2005 will be included and this is not correct

Can you help me out

Regards