# of days in report/query?

[Betty B]

Hi
I think I have a simple question but am making it harder
than it needs to be. I'm trying find a total number of
days in a report, with some of the days being the same in
a district. For example,

School Date Attended District
Walley 03/16/04 BI
Walley 01/14/04 BI
Valla 03/16/04 BI
Block 02/18/04 BI

So I would like the report to total the dates attended
for the district, i.e essentially only 3 dates (01/14,
02/18, & 03/16) for BI even though 2 schools were present
on 3/16/04. Thanks for any help.

 

[Duane Hookom]

If you are not sorting and grouping by DateAttended, then you may need to
create a separate totals query that groups by this field and then another
that counts the number of records in the query grouped by Date Attended. You
can add the final, one record query to your report's record source.