I'm sure there will be a way but I can't figure it out. I have a field (STATUS) that has Radio buttons. The Selections are either "Ready", "To Fax", "Approved"

I need to make a summary on my Main Page layout that counts how many records in field (STATUS)have "Ready" selected. I'm a beginner and can't figure it out. Count(field...) just seems to count the number of records with anything in the field, this does not work because the field may contain "Ready", "To Fax" or "Approved". I need it to count the number of records with "Ready" in the (STATUS) field.

One option was to make a script that performed a find of "Ready" in the (STATUS). and then a simple Count(STATUS), however this didn't look very good because if there were no records with "Ready" in the status field the "NO RECORDS MATCH THIS REQUEST" comes up. And I need "0" to come up.

Is there a way to stop the "NO RECORDS MATCH THIS REQUEST" window from popping up?

Suggestions greatly appreciated.

you can use the PATTERNCOUNT function for your field, such as:

CountReady = PatternCount (STATUS; "Ready")

To get the total of the "Ready", you may use a summary field based on "CountReady"

CountReadySum = Total of CountReady

To supress a pop-up, you can use:

Set Error Capture [on]

Another alternative is to use a global field in a self relationship and use the count function.

1. Create a global field of the same type as your STATUS field.

2. Create a relationship between this field and the STATUS field.

3. Set the global field value to the particular STATUS you want to check, e.g. "To Fax", etc, the same as what is entered into the STATUS field.

Commit the record.

4. Simply use count(TheRelationshipInStep2Above::AnyFieldInTheTable)

That should return a count of the number of records with the same value as the global field.

Echo