AnsweredAssumed Answered

How to show a count of a found set

Question asked by sgordon@serinocoyne on Jul 19, 2017
Latest reply on Jul 21, 2017 by philmodjunk

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