11 Replies Latest reply on Jul 21, 2017 7:54 PM by philmodjunk

    How to show a count of a found set

    sgordon@serinocoyne

      I have one table that has these fields

      "client", "show" and "Jobs"

       

      I have 38 unique clients, each has a number of shows, and many jobs under each unique show

       

      For Example:

       

      Client "A" has 5 shows, different amount of unique jobs under each show

      Client "B" has 1 show, many unique jobs

      etc., etc.

       

      I want to create a layout that will list each client and how many shows that the client has:

       

      It would look like this:

       

      Client A; Show Name A; Jobs: 10

      Client A; Show Name B; Jobs: 7

      Client A; Show Name C; Jobs: 4

      Client B; Show Name; Jobs: 15

      Client C; Show Name; Jobs: 16

       

       

       

      How would I do this?

       

       

      Thanks in advance