summing in report at group footer

C

chris_quinn26

I need to add up the number of actual dates worked at the end of the
group, so that i can show how qty per day between a date range.
Everything is perfect except for this item. I need a way to add just
unique dates. Can this be built. I can not use Count(Date) because
there are multiple items entered in same days.
 
D

Duane Hookom

Is your report grouped by date? If not, you need to create a totals query
that calcs the values and then include the totals query in the report's
record source.
 
Top