Count Specific Records in a Report

[Maryanne]

I have a Contract Type column in my monthly report. I need to have a listing of all values returned in this column and a count of how many. How can this be done?

eg.
May
PM Contracts: 5
TM Contracts: 2

June
AG Contracts: 7
PM Contracts: 12

 

[Pat Hartman]

If all you are showing are counts, you can do all the calculations with a query.

Select Format(YourDate,"yyyy mmm") As YearMonth, ContractType, Count(*) AS CountOfContracts
From YourTable
Group By Format(YourDate,"yyyy mmm"), ContractType;

If you want a recap at the end of a detail section, use a subreport with the above query as its recordsource, put it in the YearMonth footer section, and link to the main report on YearMonth.

[This message has been edited by Pat Hartman (edited 07-15-2000).]