How to return the number of checked items in a table.

[behnam]

Hi all,

I have a table and one of the fields is called resolved. This field is represented by a checkbox. How can i return the count of the number of items that are checked in this column of the table. I want to then return this value and write it in a textbox i created called text16.

Thanks for the help

[ranman256]

text16 = Dcount("[resolved]","table","[resolved]=true")

[behnam]

Thank you very much!!