Hello,
I do have this Dlookup function that works, in case that [win] is a control in my form :
I want to change it because the value [win], is actualy a string "win", so I tried the following
How can I make this work ?
I do have this Dlookup function that works, in case that [win] is a control in my form :
Code:
=Nz(Dlookup("[apostaid]";"tblApostasTemp";"[bookieID]=" & [Forms]![frmApostas]![bookerID] & " AND [jogo]= '" & [jogo] & "'" & " AND [resultado]= '" & [win] & "'");"X")
I want to change it because the value [win], is actualy a string "win", so I tried the following
Code:
=Nz(Dlookup("[apostaid]";"tblApostasTemp";"[bookieID]=" & [Forms]![frmApostas]![bookerID] & " AND [jogo]= '" & [jogo] & "'" & " AND "[resultado]=‘win’”);"X")
How can I make this work ?