I have several fields that have a number stored, 1-6, I want to know how I can total or cout how many times "1" was selected.

Database: Student Misbehaviors

Table: Each Incident

Field Student_Behavior -- Number (recorded 1-6)

Each number means….

1 = Physical Contact

2 = Foul Language

And so on

I am making a report and want to know how many times a 1 was recorded in this field.

P.S. The Field was designed this way because that’s how the data is imported.

Edited October 3, 200520 yr by Guest

For a report like this you will want to search filemaker help for the term "subsummary report"

Essentially, you sort the records by the field you want to summarize in order to group the data, then you create a summary field based on the count of that field, and place in on a subsummary layout part.

There is a new layout/report wizard in layout mode to help with this process.

You can either sort by the field and put a summary field equal to the Count of serialField in a sub-summary by Student_Behavior OR create a global number field to hold each value (1-6), a relationship from each global to Student_Behavior, and a calculation field of Count(relationshipX::serialField) for each relationship. The former method only works when previewing or printing sorted data, when all records to be summarized are found, whereas the latter works in Browse Mode, regardless of sort order or found count.