I have a table with APR data (below right). I have a query with timesheet date ranges (below left) where I need to calculate the Daily APR for the time period between the two dates. I am not sure how to lookup the dates from the query to calculate Daily APR or how to handle when the date range in the query comes between two different APR amounts. I believe the Daily APR calculation is APR/365*100
QUERY From To Daily APR TABLE From To APR 6/23/2019 6/29/2019 1/1/2019 6/30/2019 3.625% 6/30/2019 7/6/2019 7/1/2019 12/31/2019 2.625%
Let me know if you can help me get Daily APR for each of the seven day timesheet periods in the query.
Thanks