Search results

  1. S

    Insert into table values from main form and subform

    Hi Experts, I have a table called payments with the following fields; Customer_ID, Loan_ID, Payment_Type, Schedule_ID, Gross_Paid, Net_Paid, Payment_Date And i would like to insert data into the table and the data is in both the main form and sub form as follows; Main form data...
  2. S

    SUMIFS Calculated field from 1 Access Table to Another

    Hi All, I need some help from the experts. I need to create a calculated field (named "Total_Payment" - highlighted yellow in the attached excel sheet) in 1 table called "Loan_Schedules" that sums values from another table called "Payments" based on 2 criteria (the Loan_ID and Schedule_ID) and...
  3. S

    Creating an Amortisation Schedule in Access

    Hi all, I am new to the forum and using ms access. I would really like some help creating the attached excel loan schedule in access. The fields shaded yellow would be populated using a form and those shaded green would be calculated in the db. Please kindly assist with the request :banghead:
Top Bottom