AnsweredAssumed Answered

Counting Matching Records

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

Title

Counting Matching Records

Post

     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.

eg:

     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.

Outcomes