Totaling in Reports

[Guest]

Hello,

I am trying to build a report for our advisors. In the report each
advisor's total number of students shows for each month.

December 2005
Adv Total
Dje 200
Bje 234
BBE 100
Etc

I have the format working with grouping by month and only listing the
advisior names once. The problem is instead of counting the students for the
whole month it only counts the first day of the month.

I'm not sure if this is related, but I was able to get what I wanted in a
query by adding the totaling row. Date - Total:Where Criteria:Not is null
and between [start date] and [end date] Visible:No, Advisor - Total:Group By,
AdvisorCount - Total:Count

The query ask for the time frame then displays the advisors name and their
total for the specific criteria.

If anyone could help me accomplish this in report that would be great.

Thank You
David

 

[Guest]

Have you tried setting the report's Sorting and Grouping to the month and the
placing the total in the month footer. Otherwise do your grouping in your
report's record source query. This would suggest NOT displaying each date.

Duane Hookom
MS Access MVP