Takunda Mafuta
Registered User.
- Local time
- Yesterday, 19:26
- Joined
- Sep 4, 2019
- Messages
- 13
I want to query figures from a table into my query using date criteria but when I run the query I get only blanks. The expression I'm using in the expression builder is as follows. See also attached images.
Code:
XE: DLookUp("EXCRate","ExchangeRates","EXCDate=#" & [DateEntered] & "#")