Writing a script to get a total

[dcecil]

I have created a FM database for my world coins and I would like to keep a "running total" of all the different countries I have. Is there a quick script that I can use to have this displayed on a page?

Thanks

[mr_vodka]

You can create a subsummary report. There are a ton of samples on here if you need one. Do an advanced search for +subsummary +report

[dcecil]

I did the advanced search and could not find any summary info that would give me the kind of total I'm looking for, that is, not counting every instantiation of every record. For instance, I do not want it to count all 12 records that I have for Canada, just 1...for Canada, 1 for Brazil, and so on.

[comment]

See here:

http://www.fmforums.com/forum/showtopic.php?tid/135476/

[Inky Phil]

I don't know if this works in 7 but you might try creating a value list based on your country name field and then use the valuecount function to return the number of items in the value list.

[color:blue]From the help file:-

ValueCount(ValueListItems("Employees";"Employee Names") returns the total number of values in the Employee Names value list in the Employees database file.

HTH

Phil