count records w/ criteria

[skate]

I am trying to count the number of records in a subform w/ linked fields "Index". The following code works without the "SIndex" criteria, but I want to count the number of records w/ SIndex (of the subform) equalling a certain value.

= DCount("*", "Job Summary Query", "SIndex =" & SIndex And "Index =" & [Index])

 

[wh00t]

= DCount("*", "Job Summary Query", "SIndex =" & SIndex & "And Index =" & [Index])

 

[aqif]

Try This

= DCount("*", "Job Summary Query", "SIndex =" & SIndex & " And Index =" & [Index])

Here the assumption is that both fields are numeric. If they are text then it will go like this

= DCount("*", "Job Summary Query", "SIndex ='" & SIndex & "' And Index ='" & [Index] & "'")

Cheers!
Aqif