I have created two tables. 1st has fields like… Prospect_Name, Policy_No, Payment_Mode (monthly, quarterly, half yearly, yearly), Amount_Paid and Issuance_Date. 2nd table has fields like Amount_Received, Date_Received.
Kindly write a query I can use to see who is due and also status that if...