AnsweredAssumed Answered

Counting Unique Instances of a Field based on Global field Or Find

Question asked by RykionPrangh on Jan 19, 2012
Latest reply on Jan 25, 2012 by RykionPrangh

Title

Counting Unique Instances of a Field based on Global field Or Find

Post

Basically I want to be able to put something in a global search field and have it match one or more fields in an OR Find (nine fields would be searched across in the real database) and only count the unique instances of the WantUnique field from the found set.   I know how to to the OR find, the trick is counting the unique instances of the WantUnique from the found set.

So in this screenshot example the search for Jones should result in the number 3.  A search for Smith would result in 2. A search for Test would be 4, etc.

A multi-key field that lists Jones, Test, Sparky, etc. will not work as there could be thousands of different names in the real database.  This is the only type of solution I've found for similar posts.

If I could define an OR realtionship instead of the only AND option this would be easy but I don't think that's possible.

Thank you for your help.

Keep in mind the main idea is to find a solution that will work with thousands of records, not just the ten in the screenshot example.

 

Test.JPG

Outcomes