Syntax Error-Dcount

[ECEstudent]

Does anyone see anything wrong with this line of code? It keeps giving me a syntax error. thanks.

 If DCount("[OrderNumber], [ItemNumber]", "[dbo_EntryStructure]", "[OrderNumber] LIKE '" & varCod & "*' AND [OrderNumber] LIKE '*" & OrderItemRep & "' AND [ItemNumber LIKE] '*" & ItemOrderRep & "'") > 0 Then

 

[ECEstudent]

OrderNumber contains two value combination from 2 different variables if that makes sense. So I need to search for both varCod and OrderItemRep in that OrderNumber column...

 

[CJ_London]

There are a number of things wrong, you can only count a single field or use *. Also just to check are your fields (ordernumber and item number) numeric or text? if numeric you cannot use like as you are - if you need to then try Cstr([OrderNumber]) LIKE etc. You also had [ItemNumber LIKE] which is wrong.

try

If DCount("[OrderNumber]", "[dbo_EntryStructure]", "[OrderNumber] LIKE '" & varCod & "*' AND [OrderNumber] LIKE '*" & OrderItemRep & "' AND [ItemNumber] LIKE '*" & ItemOrderRep & "'") > 0 Then

 

[ECEstudent]

Thank you!! It works great now!