Dlookup Multiple Criteria

[tucker61]

I have been struggling with this for a couple of hours now.

I have a value that is a dloopkup. the lookup works on when i am only trying to lookup based on one value, but i just cant get teh cdoe right to look at 2 values.

Here are my individual Dlookups.. Can someone change this to that the SumofQty_Due is dependant on Cboxoption AND CboxContract.

thanks in advance.

=Nz(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Option='" & [cboxoption] & "'"),"")
=Nz(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Contract= [cboxcontract]"),"")

 

[Deleted member 147267]

Maybe
=Nz(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Option='" & [cboxoption] & "' AND Contract= "& [cboxcontract]"),"")

 

[vba_php]

Can someone change this to that the SumofQty_Due is dependant on Cboxoption AND CboxContract.

thanks in advance.

=Nz(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Option='" & [cboxoption] & "'"),"")
=Nz(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Contract= [cboxcontract]"),"")

try:

(dlookup("sumofqty_Due","Temp_Deliveries_Last_30","Option=" & [cboxoption] & )

but if you're using a combo box in a form instead of an actual table field, you have to reference it! =)

"field = " & forms!formName!controlName!

 

[jdraw]

See the examples in the Similar Threads at bottom of the page