Error data type DLOOKUP

0

I have the following code in access

Dim mes, año, tcambioOk As String
tcambioOk = DLookup("TCambio", "TCambioDivisaDolar", "IdDivisa=" & divisa And "MesFechaLIKE" & "'" & [mes] & "' AND " & "Año =" & "'" & [año] & "'")

The problem that generates me is that access tells me that the data types do not match, since the currency field is numeric, that of DateTime and the Year are both text. Could you help me. Thanks

    
asked by juan PABLO 07.02.2018 в 21:22
source

0 answers