Sarfaraz Hussain
New member
- Local time
- Today, 05:08
- Joined
- Jan 31, 2020
- Messages
- 2
Hi,
I have created 3 tables as per below names:-
1. Student Data (holding the personal information of individual)
2. Admission Data (which holds the data related the admission and timing etc)
3. Fee Receiving Data (which will carry fees entry on each course)
They are having relationship "Student Data" (One to One) to "Admission Data" & "Admission Data" (One to Many) to "Fee Receiving Data".
I need a Query to be made of outstanding fee (month wise) which are not paid student.
Can any one guide in it. Please.
I have created 3 tables as per below names:-
1. Student Data (holding the personal information of individual)
2. Admission Data (which holds the data related the admission and timing etc)
3. Fee Receiving Data (which will carry fees entry on each course)
They are having relationship "Student Data" (One to One) to "Admission Data" & "Admission Data" (One to Many) to "Fee Receiving Data".
I need a Query to be made of outstanding fee (month wise) which are not paid student.
Can any one guide in it. Please.