How to get the total

[MrCoffee]

Hi there, I am using filemaker to import a text log file, I need when the data is imported into the form to get the number of time it see one unique word in one of the field.

exemple: in the field "Station ID" that field contain 6000 or more of station ID number "201" "203" "207"

I need to calculate the number of time in all the records the number of time it see 201

the only way I was able to do that manualy is by going in Find mode put the number 201 and search, I need to that search for each of the station

this take time do a search for each station and I need to make it easy to use.

Hope somebody could help me

[mr_vodka]

You can create a summary report grouped by StationID. A summary field will be needed to count the numger of records grouped. If you do not want too see all the records under the same stationID, then you can just delete the body part and put the summary field and StationID in the subsummary that is grouped by SationID.

You can read up on subsummary reports by doing a search here and the help section under FM.