Skip to main content
November 11, 2013
Question

How get mupltple recordcounts from a column?

  • November 11, 2013
  • 0 replies
  • 269 views

I have multiple courses in a column and another column for the company putting on the courses.  I would like to be able to count all the courses registered per company and group the results by companies with the number of courses displayed.

Grouping in output is easy to do. However using count() sum() or recordcount will not give me a breakdown of how many classes have been registered for each company.

Ie:

Company name

Class 1…Registered(1)

Class2 …Registered(4)

Company Name

Class3…Registered (0)

Class4…Registered (1)

Any help would be appreciated.

This topic has been closed for replies.