Hi,
I have a problem with macro in Access. I have 2 tables with data:
1. Table "sl_data" contents ID and Date (Date from Table 1):
1 2017-04-30
2 2017-05-07
3 2015-01-13
....
3700 2016-02-26
About 3700 records.
2. Table "Table1" contens schedule payoff credit. Number_Contract, ID_Instalment, Date, Capital, Capital_Paid, Capital_Required
Cumulatively about 870 000 records. The main purpose is calculation for each date calculate Capital Paid and Capital Required .
For Instance, for Number Contract 1xxxx - We have 60 instalment in Table1 from date 2015-01-01 to 2025-07-01 and If I choose the date 2016-12-01 I want receive the amount of Capital_Paid and Capital_Required, but not only for one Number Contract but for all.
I think about Form with combobox. The Loop through the all records from Table "sl_data" and run a query with parameters.
Any ideas?