Easier approach to gaining a sumation

[GraeagleBill]

I have a report whose ControlSource includes two fields of special interest here, say MyField1 and MyField2. Those two fields have valid values of either 1,2,3 and 5. "Bottom line" here is that I want to include in the Report's Footer the total number of 2's observed, the number of 3's observed and the number of 5's observed within those two fields.

While I could write several lines of Select Case code in a RecordSetClone loop in the Report's Footer section, I had the idea that there could be a simpler way. I tried to think of a way to create 3 pseudo variables in the RecordSource query and use a SUM function with those variables in the ReportFooter, but I wasn't sure that it was even a possibility.

Any Suggestions?

Thanks,
Bill

[pbaldy]

How about

=Sum(IIf(MyField1 = 2, 1, 0)) + Sum(IIf(MyField2 = 2, 1, 0))

[GraeagleBill]

In the RecordSource Query or as the ControlSource of a text box in the Report Footer? I suspect you mean the latter?

[pbaldy]

I meant the latter. You could probably also create a totals query and base a subreport on it. That would be more dynamic.

[GraeagleBill]

Paul,
I knew it should be simple.
Thanks,
Bill

[pbaldy]

No problem Bill!