How to count only the checked records?

[chan0210]

As attached, it is a copy of my form. After the generation of the report, at the end of the report, i did a summary of the number of records that fall in differernt status. But that does not meet to my requirement as i only want to count the records that are checked by the check box.
In addition to that, i want the program to not only count the checked records but also to count number of checked records in the different status. Can that be done? please advise,.

 

[boblarson]

Okay here you go:

1. For txtDraft:

=Count(IIf([Status]="Drafting" And [Current]=True,0))

2. For txtSubmitted:

=Count(IIf([Status]="Submitted" And [Current]=True,0))

3. For TxtRevisionNeeded:

=Count(IIf([Status]="Revision Needed" And [Current]=True,0))

4. For txtApproved:

=Count(IIf([Status]="Approved" And [Current]=True,0))

5. Change the controlsource for the total to:

=[txtApproved]+[TxtRevisionNeeded]+[txtSubmitted]+[txtDraft]

(you had tatSubmitted, so I changed the control to txtSubmitted and then used that).

 

[chan0210]

Thanks alot!!..its work just as i wanted.

 

[chan0210]

Just a quick question. by using this count function, how do i refer to a field in a sub-form?

 

[boblarson]

I'm afraid I'm trying to work that one out right now for myself.

 

[chan0210]

Ok..i am figuring it out as well. Cant seem to achieve that. Let me know if you are able to do that. Thanks in advance and thanks again for the previous help!