Syntax error in DCOUNT statement 1

[Smoothcat74]

I'm losing my mind. I'm getting Syntax error (Missing operator) in query expression '[EmpCod] =' yet for the life of me, I don't see where that syntax error is! Can someone please help??

ProdReport.MoveFirst
Do While Not ProdReport.EOF
    If DCount("*", "EmployeeCodes", "[EmpCod] =" & ProdReport!EmployeeID) = 0 Then
        CountBad = CountBad + 1
        ProdReport.MoveNext
    Else
        CountGood = CountGood + 1
    End If
ProdReport.MoveNext
Loop

 

[PHV]

If DCount("*", "EmployeeCodes", "[EmpCod] =" & [!]Nz([/!]ProdReport!EmployeeID[!], 0)[/!]) = 0 Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Smoothcat74]

That worked like a charm!! Thank you kindly PHV! You rock!