Dcount not giving the right result

[trident]

I have a split form that shows all records, in the form, i want to know how many are active and inactive email users. i have the following information:



DB - emaildb
field name for status - emailstat
emailstat is a drop down list box and saves numbers - 33 = Active, 34 = Inactive

I used the below formula:

in a text box: =dcount([emailstat],"emaildb",[emailstat]=33)

When I created the textbox formula, it is working fine, however, it returns the total for inactive and active. When I changed to 34, it also gives me the total number and not for the inactive.

Can anyone help me on this.

Thank you.

Trident

[ranman256]

the params must be in quotes too...

Dcount("[emailstat]","emaildb","[emailstat]=33")