Value List Count

[BetterDayz]

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

[andygaunt]

Hi,

Have you tried the PatternCount function

PatternCount (The field to check, "search

[BetterDayz]

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?

[BetterDayz]

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?

[Vaughan]

Am I missing something here?

Enter Find Mode []

Set Field [ the field, "==A"

Perform Find []

[BetterDayz]

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.