Counting Active

[Rbutts25]

I am new to this site, but it seems to be the place for to find what I am looking for. I am trying to use the count function in Access to count the number of Active in a field. The Active field is designated by a check box. I want to figure out how to count how many of the boxes are checked. If anyone can help, please let me know.

Thank you,

Rbutts

 

[Mile-O]

=Count([Field])

where Field is the name of your field.

 

[Rbutts25]

I have tried this and it has not worked, I think I am puting the function in the wrong place, where does it go in the query?

 

[namliam]

select count(yourfield) from yourtable

select count(*) from yourtable where yourfield = true

Either should do the trick

Regards