Hello,
In the attached database I have a table called APR with rates for six month periods. It has been updated with a new rates for the periods beyond 06/30/2020. I created a select query with the following formula, however it only runs through 06/30/2020 for some reason. Once I get this to work for all dates, I need to change it to an update query so it changes the daily apr accordingly.
IIf([Daily APR]![MDY]>=[APR]![From],IIf([Daily APR]![MDY]<=[APR]![To],[APR]![APR]/DateDiff('d',[APR]![From],[APR]![To])))