DCount ???

[shiro]

Hi All,
Is this expression wrong
=DCount("[WattCurr1]","[Inspection result_sbfrm]","[Judge]='OK'")

otherwise it return me #Error or at another attempt #Name.

 

[Jeanette Cunningham]

Shiro, the bit that is wrong is [Inspection result_sbfrm]

Replace the subform with either the name of a table or a query.
You must use either a table or a query for the 2nd part of the DCount

for example =DCount("[WattCurr1]", "qryWatt", "[Judge]='OK'")

for more explanation
from the VBA editor window, put your cursor in the word DCount and press F1

Jeanette Cunningham