Quick one, i'm currently trying to figure out a dlookup expression in a Query field
So i'm trying to write this expression where I wanted to do a Dlookup from another field within the same query (Date Rejected) to return a Date by looking at the date between 2 dates in a table
Code:
Expr1: DLookUp("[DateTo]","LUP-Trend-FinWeeks","[LUP-Trend-FinWeeks].DateFrom' <=#" & [DateRejected] & "# [LUP-Trend-FinWeeks].[DateTo] >= #" & [DateRejected] & "#")
i.e.
If Rejection Date = 5/1/21, I want the DLookup to return 7/1/21
1/1/21 |
7/1/21 |
8/1/21 |
14/1/21 |
15/1/21 |
22/1/21 |
23/1/21 |
30/1/21 |
obviously this is purely an example.
Any ideas?