Hello All,
I am having an issue using calculated fields in a query with Dlookup.
I have a query that needs to pull data from another table based on another field in the same query.
Exp1 in query:
SCOD Due: DLookUp("[SCOD Date]","SCODS","[Rank] = " & [CAL Table]![Rank])
I want the SCOD Date...