summing in report at group footer

  • Thread starter Thread starter chris_quinn26
  • Start date Start date
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.
 
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.
 
Back
Top