Hi
I have following dlookup for multiple criteria but it is not producing the desired result, i am pulling the exchange rate for particular currency on particular date from tblExchangeRates.
the PK of tblExchangeRates is [ExchangeID]
result text box is blank and no errors.
I have following dlookup for multiple criteria but it is not producing the desired result, i am pulling the exchange rate for particular currency on particular date from tblExchangeRates.
Code:
=DLookUp("[Rate]","tblExchangeRates","[Currency] = '" & ![cboForeignCurrency] & " And [ExhDate] = #" & [txtDate] & "#" & "'")
the PK of tblExchangeRates is [ExchangeID]
result text box is blank and no errors.
Last edited: