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

    How to show a count of a found set


      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