Hi,
I am new here and need some help with my Access Query. I am trying to pull the first letter that was sent by our associate after a date.
For example...
We have "Letter Codes" and "Transaction date" in table 1 and "Decision Date" in table 2. I would like to pull the first letter code that was sent out after the "Decision Date" date. So if the date in "Decision date" is 04/18/2013, i would like to look for the "Transaction Date" that is >=04/18/2013 and only pull the first "Letter Codes" record. Hope this makes sense.
Thanks!