Totals Query Record Count with Criteria

[rmoreno]

Hi all. I have been working on a Totals Query and I can't get the results I want. I cannot find the right way to count my records with simple criteria such as "Pass", "Fail" or "OVR". Can someone tell me how to do this please. I have attached an example of what I want to do. Thanks

[pbaldy]

A field like:

Pass: Sum(IIf([P/F] = "Pass", 1, 0))

[rmoreno]

OH man. I can't belive how simple that was. I was way over thinking this problem by trying to use DCOUNT, COUNT, and IIF statements. Thank you for helping me see how simple this really was.

This issue is SOLVED.

[pbaldy]

No problemo!