Hi there,

I am trying to make a script or a summary field that will find the number of records with a certain value in the value list. Basically, each of my records is either listed has an "A" or "B" value in a field. I want to find the number of records that has an "A" in the field.

Any suggestions would be greatly appreciated.

Thanks

Hi,

Have you tried the PatternCount function

PatternCount (The field to check, "search

Sounds cool. But whenever I enter the script editor, it only has a set number of commands that you have to select from a list. Where would I type in a custom script like this?

Oops, heh heh, you meant to do this under the define fields option right? Yeah, it works great, but I'd like to do a summary for the entire database, searching all the records for 'A's. Is this possible?

Am I missing something here?

Enter Find Mode []

Set Field [ the field, "==A"

Perform Find []

After messing around for a bit (thanks to andygaunt for giving me a jump start), I came up with a field in the header of my database:

Field 1 (for calculation only, no display needed):

PatternCount( A_B_Takes, "A")

Field 2 (displayed in header of database):

Summary field -> Total of A_B_Takes

This gave me a field that always displays the current number of "A"s displayed.