Counting Unique Values

[novicius]

Hi all,

I've just run through a few searches and haven't really seen a thread pertaining to my question.

I'm working on a client's simple single-file (no other relationships established, grr) FileMaker Pro 7 database and I can't seem to figure out a way to count the unique, repeating values. In a perfect world, this would be a fully fleshed-out DB and I could just slap a summarizing COUNT on the field in question in its own file, but here since there are repeats, the COUNT function is just counting every instance of a value.

Again: I need a way to count only the different types of a value, not every instance of a value.

Thank you!

- novicius -

 

[JeanW]

make a global field that holds the type of the values.
make a self joint relationship between your field and the global
make your count through the relationship, something along the lines of :

count (selfjointname::yourfield)

HTH