I am trying to lookup Conversion Rates based on a user-entered Invoice Date in an Access 2016 form. Here is a sample of the Rate Table:
General - Daily FX Rate History
Rate_Date Effective_Date USD-CAD CAD-USD
3/1/2017 3/2/2017 1.3335 0.7499
3/2/2017 3/3/2017 1.3399 0.7463...