another count question

[bjarvis]

here's what I have in my text box
=count([statusid]where[statusid]=1)
after I enter this it gives me an invalid syntax message. What am I doing wrong.

 

[JerryDennison]

You can't use criteria with anything other than aggregate functions(i.e. DCount()). So, either filter the recordset so that only those records matching your criteria are returned or use the DCount() function. Keep in mind, aggregate functions require that you pass the field AND domain(i.e. table or query) to the function. Passing the criteria to a domain aggregate function is optional.