Report Counts

[JaB]

Morning

I have a report that brings back various fields from a table, one of the
fields being a date.

My report gives a total of records at the bottom but Id also like it to
subtotal records by date. Any ideas how to do this?

Many thanks

 

[John Spencer]

In the report's sorting and grouping dialog (View: Sorting and Grouping) add a
group based on the date field and set group footer to Yes.

Copy the controls that are in the report footer section.
Paste them into the group footer section.

That should do it, although you may have to adjust labels and positions.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[JaB]

Thanks for that John.

Its almost worked, its total groups but for some reason its not grouping
together entries of the same date, its treating them all as separate entities
so all group totals are '1'.

Any ideas whats not working?

Thanks

 

[John Spencer]

First guess would be that your date has a date and time.
If that is the case.

Change the group by to
=DateValue(YourDateField)
to strip off the time component.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

Your date field might also store a time element like 11/12/2008 12:35 PM. You
can set the sorting and grouping to an expression like:
=DateValue([YourDateField])