I've been searching through the archives and while I see that folks try to avoid using these kinds of calculated field, I'm afraid that my boss pretty much insists on viewing his data this way.
What I'm trying for:
A form with calculated fields which count: the total # of visits we've had, how many men vs. women (this is a combobox based on a value list in the originating table), how many ESL students (this is a yes/no field), and several other details along the same lines.
I have a filter which asks for the semester for which my boss needs these numbers and that does successfully give the total number of visits we've had.
How do I use calculated fields to give me the breakdown of these other details? An example of the yes/no field I tried is this:
=DCount("[ESL]","[ESL Query]","[ESL] = 0")
but I'm not getting correct results.
(Right now I'm getting results of 0; in some other permutation that I don't remember I was getting a result of 1. I should have 3 if it's NOT still using the filter correctly or 2 if it is behaving exactly right.)
I'm guessing that either my query is messed up -- but it works fine on its own -- or that I've yet again not fully undestood the syntax for what I'm trying to do.