AnsweredAssumed Answered

Find fields that repeat XX number of times

Question asked by Yoshihide on Jan 10, 2010
Latest reply on Jan 11, 2010 by comment_1

Title

Find fields that repeat XX number of times

Post

Hi, this is the first time here, and need help in finding a record.

 

What I'm trying to do is to find a record that contains a certain text in the field more than XX number of times.

 

For example, let's say that there is a record containing a "State" field like the one below.

 

1  New York

2  Washington

3  Washington

4  Florida

5  California

6  California

7  California

8  Florida

9  Florida

 

What I'd like to do, in this case, is to find a record that contains a "State" which exists more than 3 times.

That would be California and Florida.  Records that contain New York, and Washington are not needed.

 

So the search result would reveal records 4 ~ 9

 

 

Is finding a record in such a way possible?

 

 

Thanks,

Yoshihide

Outcomes