Payment due question
Posted on 1999-06-22
Greeting of peace ...
I'm developing a student info. system. I am using VB 6 as a front end and MS-ACCess 97 for backend. i need the SQL statement. Hopefully, you can help me guys.
STUDENT table will have StudentID, IntakeDay, Name and etc.
e.g. ( 9901, '01-Feb-1999', 'Rama')
( 9902, '01-Feb-1999', 'Ali')
9903, '01-Jun-1999', 'John'
PAYMENT table will have PayID, StudentID, MonthPaid, AmountPaid.
(1, 9901, '02-Feb-1999', 400.00
2, 9901, '02-Mar-1999', 400.00
3, 9902, '02-Feb-1999', 400.00 )
Now, i need to print a report for those who didn't pay for a particular month.
e.g. For the month of March 1999 from 1-March-199, the SQL should display ONLY (9902, 'Ali') and NOT (9903, 'John')
For the month June 1999, it should display all 3 records which are 9901,9902 and 9903 because nobody paid so far.
So, i need the SQL Statement for that URGENTLY. I'm using MS-Access 97. If you cannot solve the problem using one sql, may be you can guide me to solve the problem asap.