AnsweredAssumed Answered

Counting values

Question asked by NormanStock on Nov 24, 2010
Latest reply on Nov 29, 2010 by NormanStock


Counting values


Forgive the possibly very simple question - but I am not an experienced user of FileMaker (despite using it for years). I have a database which has a field which only contains values from a value list. What I would like to do is display how many of each value in that value list the whole database contains. For example (and this is not describing my database but the principle is the same and hopefully easy to understand) if the database was of customers and their orders with a field that was the customers name (from a value list) and each record was of an order they had placed, what I am trying to obtain is a list of the customers (the names in the value list) and the number of orders that they have placed - if you like a league table of customers based on the number of orders placed.

Thanks in advance for any help you can give