Counting Matching Records
I want to count and present (in a printable format) the number of records that match a found set. The values I am searching for are fixed. It should be auto-updating.
1 record has "foo" in field x
4 records have "bar" in field x.
Building upon that I want to be able to display a count of records that match multiple fields.
1 record has "foo" in field x, "bar" in field y.
3 records have "bar" in field x and "foo" in field y
I think I want to run a Find then a Get(FoundCount) but I cannot figure out exactly how to do that.
I was wondering if a report might be a better way to go about this.