pull information from a field in another table from the respective field based on the month of the year
I have two tables. "Processing" and "Monthly Interest Rate".
I have a field in the processing table that is called [interest rate]
I have fields in the "interest rate table" called [JAN 2018], [FEB 2018], [MAR 2018] and so on.
I want to pull the value of the corespondent field from table "Monthly Interest Rate"
If we are in the month of February of 2018, than the rate that would apply is the value on the field [FEB 2018] and it would fill out the field [interest rate] that is in the table "processing".
I would appreciate if someone could help me make that formula?
Thank you!
I have a field in the processing table that is called [interest rate]
I have fields in the "interest rate table" called [JAN 2018], [FEB 2018], [MAR 2018] and so on.
I want to pull the value of the corespondent field from table "Monthly Interest Rate"
If we are in the month of February of 2018, than the rate that would apply is the value on the field [FEB 2018] and it would fill out the field [interest rate] that is in the table "processing".
I would appreciate if someone could help me make that formula?
Thank you!
