Unanswered: count the number of occurrence in a pull-down list
Please help and advice how to count the number of occurrence in a pull-down list. This list has our SALESMAN's name (5 of them). And each JOB has only one SALESMAN. We have hundreds of JOBs for different CLIENTs.
I have made a summary report and have sorted and listed all the CLIENT with their sales amount from the highest to their lowest using “Sub-summary when sorted by: (CLIENT and SALESAMOUNT)”. I have also listed the number of job each CLIENT has done by counting each (JOB). But I am having trouble listing the number of job each salesman are responsible under the same line for the client.