AnsweredAssumed Answered

Counting Matching Records

Question asked by RyanMutton on Nov 13, 2013
Latest reply on Dec 3, 2013 by philmodjunk


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.