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

Outcomes