Re: Formula to divide column by total

yes, but you will need to set the date range in two new fields on the Inspections totals record, and look up those two dates down to the detail report.  Then use those dates as report filters.  That will control both the details on the report and the count of total inspections.

I suggest that if you do this, that you make a formula field to use as a report break heading  as a Group By  in the report to remind the user of what date range is set.


e.g. 

"<font color = blue>Date Range: <font color=red>" & List(" - "  ToText([Start Range Lookup]), ToText([End Range Lookup]))