Count or DCount Not Working Properly

[Chris1112]

In a textbox on the Form Footer, I'm trying to count the number of records that meet a criteria. In using Count in one and DCount in the other. Here's my formula.

=Count([MaxOfSTAGE]<2)
=DCount("[MaxOfSTAGE]","qryCAData","[MaxOfSTAGE] < 2")

qryCAData is the query that the record source for the form. [MaxOfSTAGE] is a required numeric field. Count displays the total number of records, ignoring criteria, and DCount always gives me zero. Any help on what could be happening here?

[pbaldy]

Count doesn't have a criteria. Try

=Sum(IIf([MaxOfSTAGE]<2, 1, 0))

The DCount() looks fine, so double check your values. You might try:

=DCount("*","qryCAData","[MaxOfSTAGE] < 2")

[Chris1112]

I need to be slapped. Your Sum appears to work but I jus realized that the DCount was working. None of my sample data had a MaxOfSTAGE value below 2.

[pbaldy]

Okay, where do you live? I'll send over the nearest slapper.

Glad you got it sorted out.