Recent content by djcbooks

OMG - it was the space in front of my table name causing the issue!!! Thanks so much for the quick reply and eagle eyes!!

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...