DLookUp problem

[radek225]

I want to see if there is some kind of record in "technologia" field in table "tblDolZlecenia" where "technologia" = 1 and where tblDolZlecenia.id_zlecenia = forms!frmZlecenieMarzena!id_zlecenia (id_zlecenia is a text field)
So I built DLookUp, the problem is, that two criteria won't work together but separately working good.

Nz(DLookup("[technologia]", "tblDolZlecenia", "[Id_zlecenia]='" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & "'" And "[technologia] = 1"), 0)

Does anyone know why is that?

 

[pr2-eugin]

Try this..

Nz(DLookup("[technologia]", "tblDolZlecenia", _
     "[Id_zlecenia]='" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & "' And [technologia] = 1"), 0)

When Concatenation conditions, take a careful look !

 

[radek225]

Working gooooooood, thx

 

[pr2-eugin]

Good Luck !

 

[SmallTime]

or even

Nz(DLookup("[technologia]", "tblDolZlecenia", "[Id_zlecenia]=" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & " And [technologia] = 1"), 0)

 

[pr2-eugin]

or even

Nz(DLookup("[technologia]", "tblDolZlecenia", "[Id_zlecenia]=" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & " And [technologia] = 1"), 0)

SmallTime, you missed a 'Small' detail the OP mentioned that the Id_zlecenia is a Text field !

 

[SmallTime]

Nice Spot, I'm gonna give you a thumbs up too