Groups

[kingsgambit]

I want a report to show a group title and count the number of items in that group.I have a database with businesses in it, the report should show.
The Name of the company
Next level the month, next to that the total number of invoice for the month, and the total cost.
Then the next month and so on.
Then start with the next company.
So far I can get the month, but it produces all the invoices instead of a number.

 

[Rich]

Create a new query which groups by Month and Customer CountInv, Sum cost, use the query as a sub report Link by customerID